Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24981 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
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Can you sum a count in sql?
How do I order by ascending in sql?
What is delete command in sql?
What is a trigger word?
What is difference between inner join and cross join?
Is like operator in sql case sensitive?
What is restrict in sql?
What are literals in sql server?
how to create a new view in mysql? : Sql dba
how mysql optimizes distinct? : Sql dba
Can ddl statements be used in pl/sql?
Differentiate between syntax and runtime errors.
What is type and rowtype in pl sql?
Why is a trigger used?
