Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| partition_id | bigint | 8 | null |
|
|
|||
| object_id | int | 4 | null |
|
|
|||
| index_id | int | 4 | null |
|
|
|||
| partition_number | int | 4 | null |
|
|
|||
| rows | bigint | 8 | null |
|
|
|||
| filestream_filegroup_id | smallint | 2 | null |
|
|
|||
| is_orphaned | bit | 1 | √ | null |
|
|
||
| dropped_lob_column_state | tinyint | 1 | √ | null |
|
|
||
| is_unique | bit | 1 | √ | null |
|
|
||
| is_replicated | bit | 1 | √ | null |
|
|
||
| is_logged_for_replication | bit | 1 | √ | null |
|
|
||
| is_sereplicated | bit | 1 | null |
|
|
|||
| max_null_bit_used | smallint | 2 | null |
|
|
|||
| max_leaf_length | int | 4 | null |
|
|
|||
| min_leaf_length | smallint | 2 | null |
|
|
|||
| max_internal_length | smallint | 2 | null |
|
|
|||
| min_internal_length | smallint | 2 | null |
|
|
|||
| allows_nullable_keys | bit | 1 | √ | null |
|
|
||
| allow_row_locks | bit | 1 | √ | null |
|
|
||
| allow_page_locks | bit | 1 | √ | null |
|
|
||
| is_data_row_format | bit | 1 | √ | null |
|
|
||
| is_not_versioned | bit | 1 | √ | null |
|
|
||
| filestream_guid | uniqueidentifier | 16 | √ | null |
|
|
||
| ownertype | tinyint | 1 | null |
|
|
|||
| is_columnstore | bit | 1 | √ | null |
|
|
||
| optimize_for_sequential_key | bit | 1 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
