Truncate is a DDL command and hence cant be rolled back where as delete is

What is difference between TRUNCATE & DELETE?

Question Posted / deva

Answer Posted / deva

Truncate is a DDL command and hence cant be rolled back
where as delete is DML command and thus can be rolled back
if not necessary.

Is This Answer Correct ?

31 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Is hadoop a nosql?

946

what is a field in a database ? : Sql dba

986

what are integrity rules?

963

how to enter binary numbers in sql statements? : Sql dba

921

how would you enter characters as hex numbers? : Sql dba

934

how to drop an existing index in mysql? : Sql dba

1016

What are different clauses used in sql?

1066

What does t sql mean?

895

What is thread join () in threading?

942

How many joins can you have in sql?

880

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1212

How to display the current date in sql?

1007

What is rank dense_rank and partition in sql?

966

What type of database is sql?

977

Mention what does the hierarchical profiler does?

1020