Question: what is the difference between alter and drop?
Answer: Alter is used to modify an existing table, for example by adding a column to it. It also does the best job it can at preserving the existing data. ... Drop is used to remove a table completely. You can drop and then recreate a table, but you will lose all the data it.