In this blog I am determining the Schema of a objects and How to change the schema of a objects in SQL Server using below given Query. This query show all Schema of a objects in Existing database and we can change the schema of a objects of any database.

Get Schema of a objects
SELECT TABLE_SCHEMA AS SchemaName,
TABLE_NAME AS TableName
FROM INFORMATION_SCHEMA.TABLES
1.png
change Schema of a objects

2.png

After Change Schema of a objects:
SELECT TABLE_SCHEMA AS SchemaName,
TABLE_NAME AS TableName
FROM INFORMATION_SCHEMA.TABLES
3.png