alter schema sql
snippet in sql

alter schema sql

user2581

ALTER SCHEMA toSchemaName TRANSFER fromSchemaName.TableName

change table schema sql server

user2592

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

alter table name including schema

user4661

ALTER TABLE domain.old RENAME TO new