Posted on 2019/04/222019/04/22 by tfumiaki [SQLServer]スキーマ所有者を一覧する スキーマ所有者を一覧するクエリ 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 Tweet