Question

differentiate between drop table drop clauses of alter table​

Answer 1

Explanation:

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