Difference between delete and truncate

Delete: Whenever we are using delete from tablename, then automatically deleted data internally stored in buffer. We can get it back by using rollback command.

Truncate: When ever we are using truncate table tabllename, then all rows are permanently deleted. We can not get it back this by using rollback. Because DDL(Data Definition Language Language) command transactions are automatically committed.

CheapSexCams
Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: