Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| partition_id | bigint | 8 | null |
|
|
|||
| partition_column_id | int | 4 | null |
|
|
|||
| modified_count | bigint | 8 | null |
|
|
|||
| max_inrow_length | smallint | 2 | √ | null |
|
|
||
| is_replicated | bit | 1 | √ | null |
|
|
||
| is_logged_for_replication | bit | 1 | √ | null |
|
|
||
| is_dropped | bit | 1 | √ | null |
|
|
||
| system_type_id | tinyint | 1 | √ | null |
|
|
||
| max_length | smallint | 2 | √ | null |
|
|
||
| precision | tinyint | 1 | √ | null |
|
|
||
| scale | tinyint | 1 | √ | null |
|
|
||
| collation_name | sysname | 256 | √ | null |
|
|
||
| is_filestream | bit | 1 | √ | null |
|
|
||
| key_ordinal | smallint | 2 | null |
|
|
|||
| is_nullable | bit | 1 | √ | null |
|
|
||
| is_descending_key | bit | 1 | √ | null |
|
|
||
| is_uniqueifier | bit | 1 | √ | null |
|
|
||
| leaf_offset | smallint | 2 | √ | null |
|
|
||
| internal_offset | smallint | 2 | √ | null |
|
|
||
| leaf_bit_position | tinyint | 1 | √ | null |
|
|
||
| internal_bit_position | tinyint | 1 | √ | null |
|
|
||
| leaf_null_bit | smallint | 2 | √ | null |
|
|
||
| internal_null_bit | smallint | 2 | √ | null |
|
|
||
| is_anti_matter | bit | 1 | √ | null |
|
|
||
| partition_column_guid | uniqueidentifier | 16 | √ | null |
|
|
||
| is_sparse | bit | 1 | √ | null |
|
|
||
| has_default | bit | 1 | null |
|
|
|||
| default_value | sql_variant | 8000 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
