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.

Related questions

+2 votes
asked Jan 15, 2022 in Sql by GeorgeBell
+1 vote
asked Jul 29, 2020 in Oracle by Hodge
...