What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20357 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
How many types of privileges are available in sql?
What is the usage of distinct keyword?
What is the difference between the conventional and direct path loader? : aql loader
what is 'mysqld'? : Sql dba
what is data integrity? : Sql dba
Can ddl statements be used in pl/sql?
Explain the types of joins in sql?
What is foreign key in sql with example?
How do you explain an index number?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is scalar function in sql?
How to add new employee details in an employee_details table with the following details
What are the syntax and use of the coalesce function?
Are sql connections encrypted?
how to check server status with 'mysqladmin'? : Sql dba
