Can we use Truncate command on a table which is referenced
by FOREIGN KEY?
Answer Posted / 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 |
Post New Answer View All Answers
How to move database physical files in ms sql server?
Differentiate between a local and a global temporary table?
Explain about SQLOS?
what are cursors? : Sql server database administration
Define self join?
What are the features of Embedded SQL
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain filtered indexes benefits?
What is the language structure to add a record to a table?
How to get the number of affected rows?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What does normalization do to data?
What are the differences between triggers and stored procedures?
Explain the difference between HTTP and HTTPS in database?
How do I start sql server 2017?