How to change table schema ?

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  March 27, 2006 at 7:50 am

  #167662

  I have a table schema1.table1 and I need to change it to schema2.table1 .

  sp_rename does not seem to work, it actually leaves table in same schema. Insert into / Select into is the last resort because this table is very large and copying will take signifficant amount of time. Are there any other options ?

  Thanks

   

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  March 27, 2006 at 8:09 am

  #628942

  Hello Mark

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=268558

  ---

  Kindest Regards,

  degrem_m
  Degremont