1USE AdventureWorks2012;
2GO
3ALTER SCHEMA HumanResources TRANSFER Person.Address;
4GO
5
1-- change schema from [dbo] to [exe]
2IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'exe'))
3BEGIN
4 EXEC ('CREATE SCHEMA [exe] AUTHORIZATION [dbo]')
5END
6
7ALTER SCHEMA exe
8 TRANSFER dbo.Employees
9