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

Why would you call update statistics?

1007

How to concatenate two character strings together?

1110

Can I disable or restrict ssrs export formats (rendering formats)?

150

How data can be copied from one table to another table?

944

What are drilldown reports?

152

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

974

What is deploy, process and build? : sql server analysis services, ssas

1099

What is the security principal at the server level that represents your session?

1008

How to convert binary strings into integers in ms sql server?

1023

Can two tables share a primary key?

1012

explain what is raid and what are different types of raid configurations? : Sql server database administration

995

why would you call update statistics? : Sql server database administration

1078

How to run queries with sql server management studio express?

1079

What is stored procedures?

1020

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1081