Select Database Schema Name with their Owner Name

SELECT s.[name], s.[schema_id], aa.CATALOG_NAME, aa.SCHEMA_OWNER
  FROM sys.schemas s
JOIN INFORMATION_SCHEMA.SCHEMATA aa ON aa.[SCHEMA_NAME] = s.[name]

No comments: