1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we use Truncate command on a table which is referenced
by FOREIGN KEY?

Question Posted / guest

Answers were Sorted based on User's Feedback



Can we use Truncate command on a table which is referenced by FOREIGN KEY?..

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

Can we use Truncate command on a table which is referenced by FOREIGN KEY?..

Answer / samji

Cacase can be used to delete a table which is referenced
by FOREIGN KEY

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What stored by the master? : sql server database administration

0 Answers  

What are triggers in ms sql server?

0 Answers  

What is the sql profiler?

0 Answers  

What are different types of constraints?

0 Answers  

Can we write ddl in trigger?

0 Answers  




How can i Relate Tables in SSIS

0 Answers   HCL,

Are resultset updatable?

0 Answers  

What is database architecture? : SQL Server Architecture

0 Answers  

How to genrate automaticlly empid like gt001

4 Answers  

What is a trigger? Why we need it?

0 Answers   Accenture,

What is a function? Give some example?

3 Answers  

What is “asynchronous” communication in sql server service broker?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories