Script to DROP and RE-CREATE all Primary and Foreign Key Constraints on all Tabl

• Weegee71

  SSChasing Mays

  Points: 607

  More actions

  April 26, 2021 at 1:28 pm

  #3875864

  Hi

  Does anyone know of a good way to Drop and Recreate all Primary and Foreign Key Constraints for all tables in a database please?

  Ive looked at various solutions but they dont seem to capture and recreate all the PK and FK constraints for all tables

• Ken McKelvey

  SSCoach

  Points: 18910

  More actions

  April 26, 2021 at 1:34 pm

  #3875865

  https://www.mssqltips.com/sqlservertip/3443/script-all-primary-keys-unique-constraints-and-foreign-keys-in-a-sql-server-database-using-tsql/

  • This reply was modified 4 years, 1 month ago by Ken McKelvey.

• Thom A

  SSC Guru

  Points: 99137

  More actions

  April 26, 2021 at 3:09 pm

  #3875894

  Out of interest why do you want to do this? What are you trying to by dropping all your constraints and then simply recreating them?

  Constraints need to be dropped in a specific order too when dealing with keys. You can't drop a primary key until all of the foreign keys referencing it are dropped too, so you need to ensure any script you do create does things in the right order as well.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk