Query name, principal_id, type_desc, default_schema_name, is_fixed_role from sys.database_principals : sys.database_principals « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sys.database_principals
24> SELECT name, principal_id, type_desc,
25>     default_schema_name, is_fixed_role
26> FROM sys.database_principals
27.3.sys.database_principals
27.3.1.Query name, principal_id, type_desc, default_schema_name, is_fixed_role from sys.database_principals
27.3.2.sys.database_principals INNER JOIN sys.objects