Drop vs Truncate Table in SQL
The DROP TABLE statement is used to drop or completely delete an existing table in a database. Deleting a table will result in loss of complete information stored in the table.
If two tables are related with a primary key and foreign key link, a referential integrity constraint may prevent you from dropping one of those tables.
DROP TABLE table_name;
The TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.
TRUNCATE TABLE table_name;