スキーマ所有者を一覧するクエリ
select
sc.schema_id as SchemaId,
sc.name as SchemaName,
dp.principal_id as PrincipalId,
dp.name as PrincipalName
from sys.schemas as sc
inner join sys.database_principals dp on sc.principal_id=dp.principal_id
ツッコミ歓迎
select
sc.schema_id as SchemaId,
sc.name as SchemaName,
dp.principal_id as PrincipalId,
dp.name as PrincipalName
from sys.schemas as sc
inner join sys.database_principals dp on sc.principal_id=dp.principal_id