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

Do you know how to send email from database?

1045

can we have a nested transaction? : Sql server database administration

1183

How to recompile stored procedure at run time?

1116

Explain some stored procedure creating best practices or guidelines?

1000

Why is sql server log file full?

1076

Explain aggregate functions?

1134

Determine when an index is appropriate?

1129

Is there any difference between primary key and unique with the not null condition?

997

What is the difference between mysql and sql server?

1082

Which sql server table is used to hold the stored procedure script?

1000

How to perform key word search in tables?

997

Why truncate is ddl?

1129

How can a user-defined datatype be created?

1033

How can a database be repaired?

1031

List the data types available in mssql?

1097