alter schea sql 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
USE AdventureWorks2012;
GO
ALTER SCHEMA HumanResources TRANSFER Person.Address;
GO
ALTER TABLE domain.old RENAME TO new