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 |
|
|