Get Schema of a Objects and How to Change the Schema of a Objects in SQL Server

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.

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 

 

 

change Schema of a objects

After Change Schema of a objects:

 

SELECT TABLE_SCHEMA AS SchemaName,

       TABLE_NAME   AS TableName

FROM   INFORMATION_SCHEMA.TABLES