You can use 2 methods to get information about owner of a particular schema or set of schema(s) within the database. Using INFORMATION_SCHEMA views method (which I prefer most of the times): USE <DBName> GO SELECT * FROM INFORMATION_SCHEMA.SCHEMATA Using query against system catalog: SELECT s.name AS 'Schema Name', db.name AS 'Database User ...