Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 problem ??

Author  Topic 

raky
Aged Yak Warrior

767 Posts

Posted - 2008-01-21 : 05:19:52
hi

I need to truncate some tables in my database but some tables are not truncated because they are being referenced by a FOREIGN KEY constraints.Please tell me how can i truncate those tables also.please explain the procedure in vivid manner.

thanks for going through this problem.....

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-01-21 : 05:46:16
You cannot truncate table refernced by foreign keys. Go through this forum post.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=92124

I will also suggest you going through this
http://weblogs.sqlteam.com/jeffs/archive/2008/01/17/60458.aspx

The above link will let you know that you did not think it to be apt to search for your query on google. You have 42 posts and should be intelligent enough to google first and if it is of no help , then, post your query on forum. Hope, it helps.
Go to Top of Page
   

- Advertisement -