Truncate can not fire a trigger while delete can fire a trigger

What is difference between TRUNCATE & DELETE?

Question Posted / suman chakraborty

Answer Posted / suman chakraborty

Truncate can not fire a trigger while delete can fire a
trigger

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why are sql stored procedures used?

1052

Explain the difference between triggers and constraints?

967

What is field delimiter?

1042

how to use 'mysql' to run sql statements? : Sql dba

1051

What is the limitation on the block size of pl/sql?

982

how to check myisam tables for errors? : Sql dba

1319

What is materialized view. What are different methods of refresh?

1388

What is view? Can we update view

1434

What is primary key secondary key alternate key candidate key?

1033

How does a self join work?

1109

what is sub-query? : Transact sql

1097

Cite the differences between execution of triggers and stored procedures?

1075

Explain clause in sql?

1027

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

961

what are the 'mysql' command line arguments? : Sql dba

1136