Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| object_id | int | 4 | null |
|
|
|||
| name | nvarchar | 256 | √ | null |
|
|
||
| column_id | int | 4 | null |
|
|
|||
| system_type_id | tinyint | 1 | null |
|
|
|||
| user_type_id | int | 4 | null |
|
|
|||
| max_length | smallint | 2 | null |
|
|
|||
| precision | tinyint | 1 | null |
|
|
|||
| scale | tinyint | 1 | null |
|
|
|||
| collation_name | sysname | 256 | √ | null |
|
|
||
| is_nullable | bit | 1 | √ | null |
|
|
||
| is_ansi_padded | bit | 1 | null |
|
|
|||
| is_rowguidcol | bit | 1 | null |
|
|
|||
| is_identity | bit | 1 | null |
|
|
|||
| is_computed | bit | 1 | null |
|
|
|||
| is_filestream | bit | 1 | null |
|
|
|||
| is_replicated | bit | 1 | √ | null |
|
|
||
| is_non_sql_subscribed | bit | 1 | √ | null |
|
|
||
| is_merge_published | bit | 1 | √ | null |
|
|
||
| is_dts_replicated | bit | 1 | √ | null |
|
|
||
| is_xml_document | bit | 1 | null |
|
|
|||
| xml_collection_id | int | 4 | null |
|
|
|||
| default_object_id | int | 4 | null |
|
|
|||
| rule_object_id | int | 4 | null |
|
|
|||
| is_sparse | bit | 1 | √ | null |
|
|
||
| is_column_set | bit | 1 | √ | null |
|
|
||
| type_name | nvarchar | 256 | √ | null |
|
|
||
| type_name_declaration | nvarchar | 320 | √ | null |
|
|
Table contained 0 rows