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.

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
Ebook Download
View all
Learn
View all