systypes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name sysname 256 null
xtype tinyint 1 null
status tinyint 1 √ null
xusertype smallint 2 √ null
length smallint 2 null
xprec tinyint 1 null
xscale tinyint 1 null
tdefault int 4 null
domain int 4 null
uid smallint 2 √ null
reserved smallint 2 √ null
collationid int 4 √ null
usertype smallint 2 √ null
variable bit 1 null
allownulls bit 1 √ null
type tinyint 1 null
printfmt varchar 255 √ null
prec smallint 2 √ null
scale tinyint 1 √ null
collation sysname 256 √ null

Relationships