Is there an easy way to programmatically export the SQL used to DROP/CREATE all constraints (check,unique,foreign,primary), or is the only way to munge through dbo.sysobjects?
I just posted a script to update all check constraints yesterday here. With some modification you can have it scripts out all constraints. Let me know if you need any help.
Bob ----------------------------------------------------------------------------- How to post to get the best help[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply