You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

3 lines
142 B

SELECT S1.name,S1.schema_id, S2.name AS Owner FROM sys.schemas S1
INNER JOIN sys.database_principals S2 ON S2.principal_id = S1.principal_id