Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25269 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 does varchar include?
What is sql profiler in oracle?
What is dml statement?
Is time a data type in sql?
What is the difference between sql, mysql and sql server?
Why do we need a foreign key?
What are the types of keys?
Why do we need cursor in pl sql?
Why do we use joins in sql?
How do you create a db file?
Is big data nosql?
How do you break a loop in pl sql?
What is the left table in sql?
Differentiate pl/sql and sql?
how would you enter characters as hex numbers? : Sql dba
