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

What is difference between TRUNCATE & DELETE?

Question Posted / rr

16 Answers
45732 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 the purpose of normalization?

1038

What is foreign key and example?

931

How to fetch alternate records from a table?

1232

How to download oracle sql developer?

1096

What are different joins used in sql?

1053

Which table is left in join?

976

Is oracle sql free?

981

Which join is default?

950

What are the advantages of stored procedure?

1003

Which is faster truncate or drop?

1043

Is natural join same as inner join?

931

What company owns postgresql?

1026

what is myisam? : Sql dba

1076

What is vector point function?

1050

Can you join a table to itself?

1122