Delete - temparaly delete the table we can undo it using rollback where

What is Difference Between delete and Truncate?

Question Posted / muralipitti

Answer Posted / muralipitti

Delete - temparaly delete the table we can undo it using
rollback where as

truncate= delete+commit we can't rollback it .

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I add a primary key to a table?

969

What is hibernate and its relation to sql?

1064

Is postgresql a nosql database?

1071

what is query cache in mysql? : Sql dba

990

how many columns can be used for creating index? : Sql dba

893

Is the primary key an index?

981

Is json a nosql?

914

What is crud stand for?

930

What is the difference between union and union all command?

1006

What is memory optimized table?

984

What is a primary key? Explain

919

What is nvarchar max in sql?

959

What is sqlexception in java?

938

How to use transactions efficiently : transact sql

988

What is left join in sql?

1003