Can we use Truncate command on a table which is referenced
by FOREIGN KEY?
Answers were Sorted based on User's Feedback
Answer / guest
No. We cannot use Truncate command on a table with Foreign
Key because of referential integrity.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / samji
Cacase can be used to delete a table which is referenced
by FOREIGN KEY
| Is This Answer Correct ? | 5 Yes | 2 No |
How do you troubleshoot errors in a SQL Server Agent Job?
What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
Explain multiserver query
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
Tell me about the approaches which you used to counter the DI problems.
How you can get a list of all the table constraints in a database? : Sql server administration
how to invoke a trigger on demand? : Sql server database administration
How to add an address record into adventureworkslt?
Explain Trigger with an example?
What is normalization 1nf 2nf 3nf?
Characterize join and name diverse sorts of joins?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)