The role of each system table in SQL Server 2005

SQL Server 2005 has a number of self-contained system tables, each of which has its own role, and the table below describes the respective system tables and their effects, for informational purposes only.

Sysaltfiles the primary database to save the database files

Syscharsets primary database character set and sort order

Sysconfigures Primary Database configuration options

Syscurconfigs Current configuration options for the primary database

sysdatabases the database in the primary database server

Syslanguages Primary Database language

syslogins Primary Database login account information

Sysoledbusers primary Database linked server login information

sysprocesses the primary database process

Sysremotelogins Primary Database Telnet account

syscolumns each database column

Sysconstrains per database limit

Sysfilegroups per database filegroup

Sysfiles each database file

Sysforeignkeys each database external keyword

Sysindexs per database index

Sysmenbers each database role member

Sysobjects all database objects per database

Syspermissions per database permissions

Systypes each database user-defined data type

sysusers per database user