This portal is to share my acquired knowledge related to Sql Server. I hope will be helpful for novice and professionals.

Tuesday, December 21, 2010

Truncate Parent Table

If the Foreign key references is estabilished between tables then
we can not fire Truncate Satement on Parent table weither records exists in Parent table or not.

We need to delete the reference then we can truncate table.

No comments: