SQL Server – Move tables between schemas

Ever needed to move or transfer tables or stored procedures (and presumably other database objects) from one schema to another? Then this is the command you need.

[code:tsql]

ALTER SCHEMA DestinationSchema TRANSFER SourceSchema.ObjectToMove

[/code]

Leave a Reply

Your email address will not be published. Required fields are marked *