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.
degrem_mDegremont
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply