copying tables between databases with constraints

• dcnorman

  SSC Eights!

  Points: 971

  More actions

  January 5, 2004 at 2:35 pm

  #152003

  I often have to copy the structure of a table between databases and I currently do so with a select into with an erroneous where clause (where 1=2 for example). This copies the structure well, but loses all of the default value constraints, which I would like to keep. Does anyone know of a way to copy the structure of a table, keeping the constraints associated with it?

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 5, 2004 at 3:29 pm

  #488731

  SCRIPT OUT the TABLES with ALL dependent object Seleted!

  then Run the Script on the Destination! (don't select copy data)

  (DTS WIZARD)

  
  * Noel