Difference between TRUNCATE and DELETE commands
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.
Showing posts with label truncate. Show all posts
Showing posts with label truncate. Show all posts
Subscribe to:
Posts (Atom)
