No. We cannot use Truncate command on a table with Foreign Key because of

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

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

What is history table in sql server?

938

What is the use of =,==,=== operators?

989

Can group by and orderby be used together?

993

How to transfer a table from one schema to another?

980

Please explain what is “asynchronous” communication in sql server service broker?

912

what's the maximum size of a row? : Sql server database administration

1060

whats new about truncate in sql server 2008?

2485

Explain multiserver query

1005

What is inner join in sql server joins?

1010

Is truncate autocommit?

922

How many databases Microsoft SQL server provides?

1065

How to turn off warning messages during php execution?

1019

What is page in sql server?

929

What is the Control Flow in SSIS

1073

How to use old values to define new values in update statements in ms sql server?

1241