Differentiate between Drop table and drop clause of alter table
Answers
Alter and Drop table
Explanation:
Alter is used to modify an existing table, like adding a row or column. Alter preserves the existing data. Example, deleting a column won't affect the data in the other columns. Changing a column datatype will result in conversion of existing data, which may result in data loss when there are errors such as overflows, under flows, or integrity constraint violations.
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:
DROP TABLE AND DROP clause of ALTER TABLE
Explanation:
Plz mark it as Brainliest
