Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25182 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
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
what are the types of subquery? : Sql dba
What is microsoft t sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
what are the different type of normalization? : Sql dba
What is difference between pls_integer and integer?
What is pl/sql language case sensitive?
how to start mysql server? : Sql dba
What is set serveroutput on?
What is the difference between pl and sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
How do I save the results of sql query in a file?
What is loop in pl sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
what are the differences between binary and varbinary? : Sql dba
