I love Programming, and Eager to learn New things Curious about Microsoft Products, Interested in Knowledge sharing. If you can dream IT, You can become it, If you can think IT, You can do IT, If you can believe it, you can achieve IT.
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]