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

How to create a simple stored procedure in ms sql server?

971

What is pivot and unpivot?

974

How to use values from other tables in update statements in ms sql server?

1037

How to verify the port number of the sql server?

1033

Write the syntax for stuff function in an sql server?

976

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

921

Is it possible to call a stored procedure within a stored procedure?

912

How do use Having,Group by,Group function in SQL?

1691

Explain the microsoft sql server delete command?

948

What is the default sql server instance name?

968

What is the difference between DataRow.Delete() and DataRow.Remove()?

1164

What is rank function?

974

Can binary strings be used in arithmetical operations?

879

Mention what are the different types of ssrs reports?

144

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

886