create table in mutiple schemas

• Arjun SreeVastsva

  SSCertifiable

  Points: 7141

  More actions

  October 25, 2017 at 8:06 pm

  #340245

  hi,

  i need to create single table in nearly 50 schemas.
  can anyone provide automation script for this

• Phil Parkin

  SSC Guru

  Points: 246986

  More actions

  October 25, 2017 at 8:28 pm

  #1965269

  Arjun SreeVastsva - Wednesday, October 25, 2017 8:06 PM

  hi,

  i need to create single table in nearly 50 schemas.
  can anyone provide automation script for this

  Use Excel formulas ... simple.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• SQLPirate

  SSCrazy

  Points: 2880

  More actions

  October 26, 2017 at 11:15 am

  #1965363

  Something like this will generate all the create statements...

  SELECT 'CREATE TABLE ['+name+'].[YourTable]
    (
        ID INT
    )
GO'
FROM sys.schemas where principal_id = 1

  Then you'd just need to copy/paste/execute