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
45716 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

Mention what does the hierarchical profiler does?

1087

What is the usage of sql functions?

1144

explain primary keys and auto increment fields in mysql : sql dba

974

what is sql in mysql? : Sql dba

1185

What is pl sql script?

1026

Explain 3 basic parts of a trigger.

1313

Is left join and outer join same?

1054

How do you drop a trigger?

984

What are the benefits of pl/sql packages?

1105

What is a rank in sql?

960

What is keys and its types?

1069

What is Materialized View? In What Scenario we Use Materialized View?

9508

How do I run a pl sql procedure in sql developer?

968

How to call shell script from pl sql procedure?

1275

What is offset and limit in sql?

1053