Alter schema table

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply