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 |
What are the disadvantages of primary key and foreign key in SQL?
What is the command used to recompile the stored procedure at run time?
What is trigger and different types of Triggers?
what are three different authentications to connect linked servers?
What is after dml trigger?
What stored by the model? : sql server database administration
what is mean by constraints in sql?
What are the difference between data length and length in SQL Server-2008?
What is Trigger?
Explain few of the new features of sql server 2008 management studio
Repair mdf file
when you create a database how is it stored? : Sql server database administration
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)