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