TRuncate removes all the rows in a table in one go. Delete deoes it for ea

What is difference between TRUNCATE & DELETE?

Question Posted / jude franco

16 Answers
44951 Views
Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
E-Mail Answers

Answer Posted / jude franco

TRuncate removes all the rows in a table in one go.
Delete deoes it for each row
Truncate does not make entries in a LOG file
Delete makes entries for each row that gets deleted

Is This Answer Correct ?

23 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql*plus?

1016

Why is %isopen always false for an implicit cursor?

1034

What is assignment operator in pl sql?

967

What is character functions?

1016

what is uncommittable transactions? : Transact sql

952

What are the types pl/sql code blocks?

1066

What is $$ in sql?

939

What is meant by user defined function?

984

What are the benefits of pl sql?

1052

what is user defined functions? : Sql dba

975

What is embedded sql what are its advantages?

958

What does trigger mean in slang?

1003

Is sql open source?

914

Explain autonomous transaction.

1093

how to create a new view in mysql? : Sql dba

892