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

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

Explain the disadvantages of cursors?

0 Answers  

Explain datetimeoffset data type in sal server 2008?

0 Answers  

What is normalization of database? What are its benefits?

0 Answers  

What are the advantages of passing name-value pairs as parameters?

0 Answers  




How is table type constraint applied to a table?

0 Answers  

Explain log shipping and mention its advantages.

0 Answers  

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

When would you use the stored procedures or functions?

0 Answers  

What is table-valued sub query?

0 Answers  

What are page splits? : SQL Server Architecture

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories