Categories
Sql Server

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 […]