Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| object_id | int | 4 | null |
|
|
|||
| name | sysname | 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 |
|
|
|||
| generated_always_type | tinyint | 1 | √ | null |
|
|
||
| generated_always_type_desc | nvarchar | 120 | √ | null |
|
|
||
| encryption_type | int | 4 | √ | null |
|
|
||
| encryption_type_desc | nvarchar | 128 | √ | null |
|
|
||
| encryption_algorithm_name | nvarchar | 256 | √ | null |
|
|
||
| column_encryption_key_id | int | 4 | √ | null |
|
|
||
| column_encryption_key_database_name | sysname | 256 | √ | null |
|
|
||
| bit | 1 | null |
|
|
||||
| is_masked | bit | 1 | null |
|
|
|||
| graph_type | int | 4 | √ | null |
|
|
||
| graph_type_desc | nvarchar | 120 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
