Introduction to system tables in SQL server databases

In special cases, the sysaltfiles primary database contains the rows corresponding to the files in the database. The table is stored in the master database.
Each character set in the syscharsets primary database occupies one row in the table. The table also contains the definition for Microsoft? SQL Server? The sort order used. One of the sorting orders is marked as the default sorting order in sysconfigures, which is the actual unique order.
Each configuration option set by the sysconfigures primary database user occupies one row in the table. Sysconfigures include Microsoft recently started? SQL Server? The configuration options defined earlier include all the dynamic configuration options set after the last startup. The table is only in the master database.
Each of the current configuration options of the syscurconfigs master database occupies one. In addition, the table contains four items that describe the configuration structure. Syscurconfigs is dynamically generated during user query. For more information, see sysconfigures.
Sysdatabases master database Microsoft? SQL Server? Each database occupies one row in the table. When you first Install SQL Server, sysdatabases contains the master, model, msdb, mssqlweb, and tempdb database items. The table is only stored in the master database.
The syslanguages primary database appears in Microsoft? SQL Server? Each language occupies one row in the table. Although American English is not in syslanguages, this table can always be used by SQL Server. The table is only stored in the master database.
Each Logon account of the syslogins primary database occupies one row in the table.
The user and password ing of each specified linked server in the master database of sysoledbusers occupies one row in the table. The table is stored in the master database.
The sysprocesses master database sysprocesses table stores information about running on Microsoft? SQL Server? Process information. These processes can be client processes or system processes. Sysprocesses is only stored in the master database.
Each sysremotelogins master database can call Microsoft? SQL Server? The remote users of the stored procedure take one row.
Each column in each table and view of each database in syscolumns occupies one row in the table, and each parameter in the stored procedure occupies one row in the table. The table is located in each database.
Sysconstraints each database contains a constraint ing mapped to the object with the constraint. The system directory is stored in each database.
Sysfilegroups each file group in each database occupies one row in the table. This table is stored in each database. At least one item in the table is used for the master file group.
Sysfiles: each file in each database occupies one row in the table. The system table is a virtual table and cannot be directly updated or modified.
Sysforeignkeys each database contains information about the foreign key constraint in the table definition. This table is stored in each database.
Sysindexkeys each database contains the key or column information in the index. This table is stored in each database.
Each database role member of sysmembers occupies one row in the table. This table is stored in each database.
Sysobjects each database creates each object (constraints, default values, logs, rules, stored procedures, etc.) in the database to occupy a row in the table. Each temporary object occupies one row in the table only in tempdb.
Syspermissions each database contains information about permissions granted and denied to users, groups, and roles in the database. This table is stored in each database.
Systypes each database provides data types and user-defined data types for each system, and contains a row of information. This table is stored in each database. These are the data types and ID numbers provided by the system.
Sysusers each Microsoft in each database? Windows users, Windows groups, Microsoft SQL Server? The user or SQL Server role occupies one row in the table.
Sysproperties view prompt information for each table and column in each database