Difference between TRUNCATE & DELETE commands in SQL- Interview questions

Difference between TRUNCATE & DELETE commands in SQL- Interview questions
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence
DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back.
WHERE clause can be used with DELETE & not with TRUNCATE.

No comments:

 
Top Blogs