469,926 Members | 1,516 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

Drop and recreate constraints

1
Hi,

We have a script that drops the constraints for all user tables in MS SQL Server 2000. Is there a way to script in recreating the same droped table constraints?

We want to disable the constraints to be able to truncate the user tables and then apply the same constraints after truncating.

Thanks.
Sep 11 '07 #1
0 1827

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by tchangmian | last post: by
5 posts views Thread by Markus | last post: by
1 post views Thread by Matt | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.