Alter schema table

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  March 27, 2006 at 4:14 am

  #168318

  Hi

  I have 250 tables in mySchema1 --> mySchema1.myTable1

  And I would like to change schema's name by mySchema2.myTable1

  I create a new schema : myScema2 but I don't know how I do for to change schema from my table.

  ---

  Kindest Regards,

  degrem_m
  Degremont

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  March 27, 2006 at 4:24 am

  #628846

  It's ok, I found it :

  ALTER

  SCHEMA mySchema2 TRANSFER mySchema1.myTable1;

  However, I don't find in Management Studio.

  ---

  Kindest Regards,

  degrem_m
  Degremont