Script to Retrieve Constraint Order/Sequence

• deucellion

  Say Hey Kid

  Points: 680

  More actions

  August 2, 2005 at 2:31 am

  #88230

  Hi All,

  Does anyone know where I can find a script that will automatically generate a list of table precedence based upon their referential constraints.  ie the sequence in which data will need to be inserted.

   

  Many Thanks,

  Zid

   

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  August 2, 2005 at 10:37 am

  #578908

  Here's one that I've used:

  http://www.sqlservercentral.com/scripts/contributions/445.asp

  Greg

   

  Greg