Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24486 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
Why do we use procedures in sql?
Does mysql_real_escape_string prevent sql injection?
How to use distinct and count in sql query? Explain
What is %type in sql?
define sql insert statement ? : Sql dba
What is execute immediate?
How can we link a sql database to an existing android app?
Why do we use set serveroutput on?
How many types of keys are there in sql?
What are system versioned tables?
How can a pl sql block be executed?
How do I tune a sql query?
Which table is left in join?
What is file based approach?
Is progress software supports to ( pl/sql )?
