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 do you need to connect php to sql server?
What is the difference between deallocate cursor and close cursor?
Why use “pivot” in sql server?
can any body tell me how to know the password of current user in sql server
Explain what is “asynchronous” communication in sql server service broker?
What is a data source file?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Explain hostprotectionattribute in sql server 2005?
what is bit datatype? : Sql server database administration
how do u find least salary in a table
What are the four main query statements?
what purpose does OPENXML clause have in sql server stored procedure?
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)