What Are The Differences Between Drop A Table And Truncate A Table?

1.	What Are The Differences Between Drop A Table And Truncate A Table?
Answer» DROP TABLE table_name - This will DELETE the table and its DATA. TRUNCATE TABLE table_name - This will delete the data of the table, but not the table DEFINITION. DROP TABLE table_name - This will delete the table and its data. TRUNCATE TABLE table_name - This will delete the data of the table, but not the table definition.

Answer»

DROP TABLE table_name - This will DELETE the table and its DATA.

TRUNCATE TABLE table_name - This will delete the data of the table, but not the table DEFINITION.

DROP TABLE table_name - This will delete the table and its data.

TRUNCATE TABLE table_name - This will delete the data of the table, but not the table definition.

Discussion