Shahsra
Shahsra

Reputation: 1009

How to change the Schema name and move the table into another schema?

I have a bit problem while changing the schema name. My problem is I have a table1 with schema1 and there is another schema called schema2. So how can I move the table1 in schema2?

Thanks in Advance

Upvotes: 2

Views: 3069

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300539

ALTER SCHEMA schema2
    TRANSFER schema1.table1;
GO

Ref.

Upvotes: 4

Related Questions