alter schema sql server code example

Example 1: change table schema sql server

USE AdventureWorks2012;  
GO  
ALTER SCHEMA HumanResources TRANSFER Person.Address;  
GO

Example 2: alter table name including schema

ALTER TABLE domain.old RENAME TO new