Question

Which one will delete the table data as well as table structure mcq?

Answer 1

drop tablename--- delete data as well as structure of table.

Answer 2

Delete and Truncate commands used to delete table data and structure of the table.

Explanation:

To delete some of the data or rows from the table we use DELETE command it only deletes selected data or rows and it can roll back the data.

For example DELETE from table WHERE condition;

To delete the entire schema of the table we use TRUNCATE command which deletes the entire structure of the table and it cannot be rollback the data.

For example TRUNCATE table tablename;