change schema sql 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