delete command delete the rows from table record by record but truncate

What is difference between TRUNCATE & DELETE?

Question Posted / rr

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

Answer Posted / rr

delete command delete the rows from table record by record but truncate removes all the records is nothing but it drops the table and creates table structure as it is

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between group by and partition by?

1062

Is sql between inclusive?

1132

What is difference between sql and oracle?

1131

what is a database? : Sql dba

1172

What is t sql in sql server?

1075

Is sql low level language?

1021

What are different types of sql?

1191

What is use of trigger?

933

Why is sql important?

1108

What is a sql select statement?

1041

Enlist some predefined exceptions?

1060

What will you get by the cursor attribute sql%notfound?

1075

What is a common use of group by in sql?

1051

Can a view be mutating? If yes, then how?

1028

Why do we use view in sql?

964