0 votes
in Sql by
Difference between TRUNCATE, DELETE and DROP commands?

1 Answer

0 votes
by

DELETE removes some or all rows from a table based on the condition. It can be rolled back.

TRUNCATE removes ALL rows from a table by de-allocating the memory pages. The operation cannot be rolled back

DROP command removes a table from the database completely.

...