Identifying constraints...

• tjn

  Grasshopper

  Points: 12

  More actions

  October 24, 2001 at 9:10 am

  #157584

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  October 24, 2001 at 9:45 am

  #419254

  You might be able to modify this to just display the items (or scrip them):

  http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=25&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

  Steve Jones

  steve@dkranch.net