System Tables Views MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. System Tables Views
  4. 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