SQL Server Schema Ownership

 SQL Server Schema Ownership

To display the ownership of the schemas in sql server run the following query.

To display ownership of all Schema(Query) :-

SELECT * 
FROM INFORMATION_SCHEMA.SCHEMATA

To display only specific schema information (Query):-

SELECT * 
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = 'your schema name';

How to alter authorization of schema:-

ALTER AUTHORIZATION ON SCHEMA:: TEST TO USERNAME