Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



syscolumns System Table - SQL Server 2000

Modified on Fri, May 01, 2009, 10:53 AM by Administrator Categorized as SQL Server System Tables
Contains one row for every column in every table and view, and a row for each parameter in a stored procedure. This table is in each database.

Column nameData typeDescription
namesysnameName of the column or procedure parameter.
idintObject ID of the table to which this column belongs, or the ID of the stored procedure with which this parameter is associated.
xtypetinyintPhysical storage type from systypes.
typestattinyintFor internal use only.
xusertypesmallintID of extended user-defined data type.
lengthsmallintMaximum physical storage length from systypes.
xprectinyintFor internal use only.
xscaletinyintFor internal use only.
colidsmallintColumn or parameter ID.
xoffsetsmallintFor internal use only.
bitpostinyintFor internal use only.
reservedtinyintFor internal use only.
colstatsmallintFor internal use only.
cdefaultintID of the default for this column.
domainintID of the rule or CHECK constraint for this column.
numbersmallintSubprocedure number when the procedure is grouped (0 for nonprocedure entries).
colordersmallintFor internal use only.
autovalvarbinary(255)For internal use only.
offsetsmallintOffset into the row in which this column appears; if negative, variable-length row.
statustinyintBitmap used to describe a property of the column or the parameter: 0x08 = Column allows null values; 0x10 = ANSI padding was in effect when varchar or varbinary columns were added. Trailing blanks are preserved for varchar and trailing zeros are preserved for varbinary columns; 0x40 = Parameter is an OUTPUT parameter; 0x80 = Column is an identity column
typetinyintPhysical storage type from systypes.
usertypesmallintID of user-defined data type from systypes.
printfmtvarchar(255)For internal use only.
precsmallintLevel of precision for this column.
scaleintScale for this column.
iscomputedintFlag indicating whether the column is computed: 0 = noncomputed; 1 = computed.
isoutparamintIndicates whether the procedure parameter is an output parameter: 0 = false; 1 = true.
isnullableintIndicates whether the column allows null values: 0 = false; 1 = true.

ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2023, Patrick Jasinski.