SQL Server System Table introduction

The system directory is a system table that describes the structure of objects such as databases, base tables, views, and indexes in the SQL server system. SQL Server frequently accesses the system directory to retrieve the necessary information required for normal system operation.

Several important system tables

1: sysobjects table

The main system table sysobjects of SQL Server appears in each database, which contains a row of records for each database object.

2: syscolumns table

The system table syscolumns appears in the master database and each user-defined database. It contains a row of records for each column in the base table or view and each parameter in the stored procedure.

3: sysindexes table

The system table sysindexes appears in the master database and each user-defined database. It contains a row of records for each index and each table without a clustered index, it also contains a row of records for each table including text/image data.

4: sysusers table

The system table sysusers appears in the master database and user-defined data, it contains a row of records for each Windows NT user, Windows NT user group, SQL Server user, or SQL Server role in the entire database.

5: sysdatabases table

The system table sysdatabases contains only one row of records for each system database and user-defined database on the sqlserver system.

6: sysdepends table

The system table sysdepends contains a row of records for each dependency between tables, views, and stored procedures, which appear in the master database and each user-defined database.

7: sysconnstraints table

The system table sysconsteaints contains a row of records for each Integrity Constraint defined for database objects using the createtable or alter table statement, which appears in the master database and each user-defined database.

 

-----------------

 

Functions of various system tables in SQL Server Source

Sysaltfiles: files stored in the database in the master database Syscharsets primary database character set and sorting order Sysconfigures master database configuration options Current configuration options of the syscurconfigs master database Database in the sysdatabases master database server Main database language of syslanguages Syslogins primary database Logon account information Sysoledbusers master database connection Server login information Sysprocesses master database Process Sysremotelogins master database remote login account Syscolumns each database Column Sysconstrains per database limit Sysfilegroups each database file group Sysfiles: each database file Sysforeignkeys external keywords for each database Sysindexs each database index Sysmenbers each database role member Sysobjects all database objects in each database Syspermissions permissions for each database Systypes user-defined data types for each database Sysusers each database user