Can we use Truncate command on a table which is referenced
by FOREIGN KEY?
- 2 Answers
- 9104 Views
- Shriram, I also Faced
- E-Mail Answers
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 |
Can we install sql server 2016 on windows 7?
What are the elements of dbms?
What is check constraint in sql server?
What is a rollup clause?
What is query optimizer in sql server?
Explain different types of lock modes in sql server 2000?
What are the five characteristics of good data?
What are the recovery models in sql server 2000?
What are the approximate numeric data types?
explain declarative management framework (dmf) in sql server 2008?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is the difference between inner join and equi join?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
