Question

differentiate between drop table and drop clause of alter table?
​

Answer 1

$\huge\underline\mathrm{\red{AnSweR}}$

Drop is used to remove a table completely. You can drop and then recreate a table, but you will lose all the data it. If that's an issue, then Alter is the preferred solution. However, not all changes you might want to a table definition can be done with Alter, so your only option might be to drop/create.

Answer 2

Drop is used to remove a table completely. You can drop and then recreate a table, but you will lose all the data it. If that's an issue, then Alter is the preferred solution. However, not all changes you might want to a table definition can be done with Alter, so your only option might be to drop/create