Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Truncate command on a table which is referenced
by FOREIGN KEY?
- 2 Answers
- 10116 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 |
How much does sql server 2016 cost?
to explain sql server 2000 architecture & authentication
What happens if null values are involved in bitwise operations?
What is the difference between the 2 operating modes of database mirroring?
Describe about first three Normal forms.
What are triggers? How do you invoke a trigger on demand?
How do I make a resultset scrollable?
What is the ‘fillfactor’?
select top 5 * from emp order by newid() my question is , how this query get executed?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is the partitioning method?
What are the steps you can take to avoid “deadlocks”?
-
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)
