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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply