syscolumns


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name sysname 256 √ null
id int 4 null
xtype tinyint 1 null
typestat tinyint 1 √ null
xusertype smallint 2 √ null
length smallint 2 null
xprec tinyint 1 null
xscale tinyint 1 null
colid smallint 2 √ null
xoffset smallint 2 √ null
bitpos tinyint 1 √ null
reserved tinyint 1 √ null
colstat smallint 2 √ null
cdefault int 4 null
domain int 4 null
number smallint 2 √ null
colorder smallint 2 √ null
autoval varbinary 8000 √ null
offset smallint 2 √ null
collationid int 4 √ null
language int 4 √ null
status tinyint 1 √ null
type tinyint 1 null
usertype smallint 2 √ null
printfmt varchar 255 √ null
prec smallint 2 √ null
scale int 4 √ null
iscomputed int 4 √ null
isoutparam int 4 √ null
isnullable int 4 √ null
collation sysname 256 √ null
tdscollation binary 5 √ null

Relationships