Moving Objects to Another Schema

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
ALTER SCHEMA Sales TRANSFER HumanResources.Department