SQL Server

Moving Objects to Another Schema

Posted on by WARDY IT Solutions

In SQL Server 2005 all objects in a database are now located in schemas and are not owned by individual users. In order to move an object from one schema to another in the same database the ALTER SCHEMA command can be used.

For example to move the HumanResources.Department table to the Sales schema you can use the following command:

USE AdventureWorks
GO
ALTER SCHEMA Sales TRANSFER HumanResources.Department

WARDY IT Solutions

WARDY IT Solutions - Australia's leading SQL Server consultants, trainers and Business Intelligence specialists. WARDY IT Solutions has established itself amongst the top solution providers in SQL Server technologies providing solutions for customers throughout Asia Pacific.