October 24, 2001 at 9:10 am
I'm new to SQL Server and have a friend who is running SQL Server 2000. His business has grown (good for him) and I've offered to take a look at his database and see what I could do to redesign and tune (bad for me!)
The problem is this. If I really do go ahead and redesign the schema, I want to have a script that goes out and identifies all the constraints within the schema, drops them and after creating new db objects I will create new constraints. I have multiple databases to run this against; hence, the desire for a script or stored proc. Any ideas on simply identifying all constraints associated with a schema?
Thanks!
Tom
October 24, 2001 at 9:45 am
You might be able to modify this to just display the items (or scrip them):
Steve Jones
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy