What is difference between TRUNCATE & DELETE?

Answer Posted / suman chakraborty

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

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is snowflake sql?

576


How do I create a sql script?

535


How do you update f as m and m as f from the below table testtable?

1062


What is substitution variable?

572


How can get second highest salary in sql?

499






How many unique keys can a table have?

547


How to add a column ‘salary’ to a table employee_details?

579


What is a sql select statement?

562


what is user defined functions? : Sql dba

544


What is pl/sql language case sensitive?

629


Is sql considered coding?

567


How is use pl and sql?

547


Can we commit inside a trigger?

543


What is delete command in sql?

549


What's the difference between a primary key and a clustered index?

508