| sysobjects | Contains one row for each object (constraint, default, log, rule, stored procedure, and so on) created within a database. In tempdb only, this table includes a row for each temporary object. |
| sysusers | Contains one row for each Microsoft® Windows user, Windows group, Microsoft SQL Server™ user, or SQL Server role in the database. |
| syscolumns | Contains one row for every column in every table and view, and a row for each parameter in a stored procedure. |
| systypes | Contains one row for each system-supplied and each user-defined data type. This table is stored in each database. |
| sysforeignkeys | Contains information regarding the FOREIGN KEY constraints that are in table definitions. |
| sysreferences | Contains mappings of FOREIGN KEY constraint definitions to the referenced columns. |
| sysconstraints | Contains mappings of constraints to the objects that own the constraints. |
| sysindexes | Contains one row for each index and table in the database. |
| sysindexkeys | Contains information for the keys or columns in an index. |
| syscomments | Contains entries for each view, rule, default, trigger, CHECK constraint, DEFAULT constraint, and stored procedure. The text column contains the original SQL definition statements, which are limited to a maximum size of 4 MB. This table is stored in each database. |
| sysdepends | Contains dependency information between objects (views, procedures, and triggers), and the objects (tables, views, and procedures) contained in their definition. |
| sysmembers | Contains a row for each member of a database role. |
| sysprotects | Contains information about permissions that have been applied to security accounts with the GRANT and DENY statements. |
| syspermissions | Contains information about permissions granted and denied to users, groups, and roles in the database. |
| sysfulltextcatalogs | Lists the set of full-text catalogs. |
| sysfiles | Contains one row for each file in a database. This system table is a virtual table; it cannot be updated or modified directly. |
| sysfilegroups | Contains one row for each filegroup in a database. There is at least one entry in this table that is for the primary filegroup. |