What is the difference between TRUNCATE and DROP TABLE?

Explanation

TRUNCATE and DROP TABLE have distinct functions in SQL. TRUNCATE removes all rows while keeping the table structure intact, including indexes. On the other hand, DROP TABLE permanently deletes both the data and the table definition.

Key points

TRUNCATE preserves table structure and indexes
DROP TABLE removes table definition and data
TRUNCATE is used to quickly remove data while keeping the table intact
DROP TABLE is used to completely remove the table and its data
Understanding the difference is crucial for managing databases effectively

Ready to go further?

Start full exam Practice more questions