sql change schema code example

Example 1: alter schema sql

ALTER SCHEMA toSchemaName TRANSFER fromSchemaName.TableName

Example 2: change table schema sql server

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