Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25582 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
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 do you think about pl/sql?
Is sql dba a good career? : SQL DBA
Why trigger is used in sql?
What is java sql connection?
What is a loop in sql?
Mention what are the benefits of pl/sql packages?
What are sql objects?
what are the drivers in mysql? : Sql dba
How do I sort a table in sql?
Why do we need cursor in pl sql?
what are the performance and scalability characteristics of mysql? : Sql dba
What are the different sql commands?
Why do we need a foreign key?
What is nosql db?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
