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