TABLE 3: The syscolumns System Table
Column Name Description
ID The object identifier (from sysobjects) this entry applies to
Number Subprocedure number
Colid The column ID of the column in question
Status Bitmap of column properties
Type Physical storage type (from systypes)
Length Physical length of data
Offset Offset into the row of data where this value starts
Usertype User type ID from systypes system table
Cdefault The ID of the stored procedure that generates the default value for this column
Domain The ID of the stored procedure that contains the rule for this column
Name The name of the column
Printfmt Reserved by SQL Server
Prec The level of precision for this column
Scale The scale for this column