The SQL SERVER critical system table

The sysobjects table created for each object in the database (constraint, default, log, rule, stored procedures, etc.) in the table per line. Only in tempdb, each temporary object one row in the table.

Column name Data type Description
name sysname object name.
Id int object identification number.
xtype char (2) object type. Can be in one of the following object types:
C = CHECK constraint
D = default or DEFAULT constraint
F = FOREIGN KEY constraint
L = log
FN = scalar function
IF = inline table function
P = the stored procedure
PK = PRIMARY KEY constraint (type K)
RF = Replication filter stored procedure
S = system table
TF = Table function
TR = Triggers
U = User table
UQ = UNIQUE constraint (type is K)
V = view
X = Extended stored procedure

uid the smallint owner object user ID.
info smallint reserved. For internal use only.
status int reserved. For internal use only.
base_schema_
ver int retained. For internal use only.
int reserved replinfo. For replication.
parent_obj int parent object object identification number (for example, triggers or constraints, the identification number for the table ID).
the creation date of the crdate datetime object.
full-text index registered by the ftcatid smallint full-text catalog identifier of the user table for all user tables are not registered or 0.
schema_ver the int version number, the version number is increased in each table schema changes.
stats_schema_
ver int retained. For internal use only.
Type char (2) object type. Can be one of the following values:
C = CHECK constraint
D = default or DEFAULT constraint
F = FOREIGN KEY constraint
FN = scalar function
IF = inline table function
K = PRIMARY KEY or UNIQUE constraint
L = log
P = the stored procedure
R = rule
RF = Replication filter stored procedure
S = system table
TF = Table function
TR = Triggers
U = User table
V = view
X = Extended stored procedure

The smallint retained userstat.
information of sysstat smallint internal state.
The smallint retained indexdel.
refdate datetime reserved for future use.
version int reserved for future use.
“the deltrig int reserved.
int reserved instrig,.
int reserved updtrig.
int reserved seltrig.
category int for publishing, constraints, and identification.
cache smallint reserved.

syscolumns table

Each column in each table and view one row in the table, one row for each parameter in the stored procedure in the table.The table in each database.

Column name Data type Description
name sysname column name or the name of the process parameters.
id int The table object ID column belongs, or the parameters associated with the stored procedure ID.
xtype this way tinyint the physical storage systypes type.
typestat tinyint internal use only.
xusertype smallint extended user-defined data type ID.
length in the systypes smallint Maximum physical storage length.
xprec the tinyint only internal.
XScale tinyint internal use only.
the colid smallint column or parameter ID.
The xoffset smallint internal use only.
bitpos the tinyint only internal.
Reserved use tinyint only internal.
colstat smallint internal use only.
cDefault int the column default value ID.
Domain int the column rule or CHECK constraint ID.
number smallint process group (0 represents the number of non-process items) sub-processes.
colorder smallint internal use only.
autoval varbinary (255) Internal use only.
offset smallint the column where the line offset; if it is negative, which means that the variable-length rows.
status tinyint bitmap used to describe the column or parameter attributes:
0x08 = column allows null values.
0x10 = When you add a varchar or varbinary columns, ANSI filling effect. Trailing spaces reserved varchar columns retain the varbinary column trailing zeros.
0x40 = parameter as an OUTPUT parameter.
0x80 = listed as an identity column.

type tinyint the physical storage systypes type.
usertype smallint systypes user-defined data type ID.
printfmt varchar (255) Internal use only.
prec smallint level of precision of the column.
the scale int the column number of decimal places.
iscomputed int sign of the column is calculated:
0 = not calculated.
1 = Calculated.

isoutparam int means that the process parameters are output parameters:
1 = true.
0 = false.

isnullable int indicates whether the column allows null values:
1 = true.
0 = false.

sysindexes table

Each index and table in the database in a separate line in the table. This table is stored in each database.

Column name Data type Description
Table id int ID (if indid = 0 or 255). Otherwise, the ID of the index belongs table.
status int internal system status information.
first binary (6) a pointer pointing to the first page or root page.
indid smallint index of ID:
1 = clustered index
> 1 = non-clustered
255 = text or image data table entry

root binary (6) If the indid> = 1 and <255, the root is the pointer to point to the root page. For indid = 0 or indid = 255, root is the pointer to point to the last page.
The smallint minimum row size for minlen.
keycnt the smallint keys number.
groupid smallint object on which to create the file group ID.
dpages int For indid = 0 or indid = 1, dpages used data page count. For indid = 255, set it to 0. Otherwise it is used count of index pages.
reserved int For indid = 0 or indid = 1, reserved is assigned to the page count of all indexes and table data. If indid = 255, reserved is the count of pages allocated to the text or image data. Otherwise it is allocated to the index page count.
Used int For indid = 0 or indid = 1, used is the total number of pages for all indexes and table data. If indid = 255, used for text or image data page count. Otherwise it is used to index page count.
rowcnt bigint row count based on indid = 0 and indid = data. If indid = 255, rowcnt set to 0.
rowmodctr int count the total number of insert, delete or update a row since the last update statistics.
xmaxlen smallint maximum row size.
maxirow is the smallint maximum size of the non-leaf index row.
Starting OrigFillFactor tinyint create index fill factor value. The value is retained; However, if you need to re-create the index, but can not remember the original fill factor, the value may be helpful.
The tinyint retained reserved1.
int reserved reserved2.
FirstIAM binary (6) retained.
impid smallint reserved. Index flag.
lockflags smallint used to constrain the index lock granularity consider. For example, for essentially lookup table is read-only, you can set it to only table-level lock to lock-in costs to be minimized.
pgmodctr int reserved.
Keys varbinary (816) column of the key ID list.
name sysname table name (if indid = 0 or 255). Otherwise, the name of the index.
statblob image statistics BLOB.
maxlen int retained.
rows int based on indid = 0 and indid = 1 the number of rows of data level, the value is repeated for indid> 1. If indid = 255, rows is set to 0. Providing this column for backward compatibility.