What is the difference between DELETE and TRUNCATE?
Answer Posted / manivasan.s
You cannot TRUNCATE a table that has any foreign key
constraints. You will have to remove the contraints,
TRUNCATE the table, and reapply the contraints.
You can DELETE any row that will not violate a constraint,
while leaving the foreign key or any other contraint in place.
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is coalesce in sql?
What is rollback?
What is equi join in sql?
What are the steps for performance tuning.
How do I truncate a word?
How many types of tables are there?
Are subqueries better than joins?
How do I count rows in sql query?
What does dml mean?
What are the differences between in and exists clause?
how to concatenate two character strings? : Sql dba
Is sql injection illegal?
How do I run a sql query in pgadmin 4?
Why self join is used in sql?
how to create a table index in mysql? : Sql dba