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 is snapshot replication?
What is Files and Filegroups in SQL Server & it's implementation.
What is the need for group functions in sql?
What is user defined datatypes and when you should go for them?
What are the types of database schema? : sql server analysis services, ssas
How to enable tcp/ip protocol on a sql server?
What is open database communication (odbc)?
Find first and last day of current month in sql server
What is exporting and importing utility?
Does hive support indexing?
Why use view instead of a table?
How maney row would be print after join if A table have 100 rows and B table have 50 rows...
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)