Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Query name, principal_id, type_desc, default_schema_name, is_fixed_role from sys database_principals

24>  SELECT name, principal_id, type_desc, 25>     default_schema_name, is_fixed_role 26> FROM sys.database_principals