With a make-table, it will generally overwrite (replace) the previous table. It will give a warning; something like "this table will be deleted.." before overwriting. You can also perform a delete in advance. Sometimes that helps to make things clearer to other devs working on it.
Thanks bro This really helped me wit one of my assignments in college
Glad I could help!
I would like the new table from the 'make table' to be a temp table that will be refreshed with each new run with updated table. How should I do this?
I suppose I should have a prior command to delete the table before the query is run.
With a make-table, it will generally overwrite (replace) the previous table. It will give a warning; something like "this table will be deleted.." before overwriting. You can also perform a delete in advance. Sometimes that helps to make things clearer to other devs working on it.