in Sql by
Q:
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.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
asked Dec 14, 2020 in Sql by SakshiSharma
0 votes
asked Jul 13, 2020 in Sql by Robindeniel
0 votes
asked Nov 27, 2020 in Sql by rajeshsharma
0 votes
asked Jun 11, 2020 in C Plus Plus by Robindeniel
+1 vote
asked May 29, 2019 in Machine Learning by param1987
...