Truncate Command removes all rows from a table, but the table structure, all relationships, constraints remain in the Database.
But Drop Command removes the entire table, all relationships associated with that table, all constraints in that table.
We can insert new records in a truncated table. But it is not possible when a table is dropped as it doesn't exist. | |