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
- 10382 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 |
Do you know query execution plan?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Mention the different authentication modes in sql server.
Why main is user defined function?
What is tabulation?
Why is DML provided?
1 Answers Ernst Young, Thomson Reuters,
Where can you add custom error messages to sql server?
what is the different types of backups available in sql server? : Sql server database administration
What is the significance of master, tempdb and model databases?
If user is owning any SQL Objects, can we drop that user
sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters
Does sql server 2000 clustering support load balancing?
-
Oracle (3253) - 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)
