Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| object_id | int | 4 | null |
|
|
|||
| name | sysname | 256 | √ | null |
|
|
||
| index_id | int | 4 | null |
|
|
|||
| type | tinyint | 1 | null |
|
|
|||
| type_desc | nvarchar | 120 | √ | null |
|
|
||
| is_unique | bit | 1 | √ | null |
|
|
||
| data_space_id | int | 4 | null |
|
|
|||
| ignore_dup_key | bit | 1 | √ | null |
|
|
||
| is_primary_key | bit | 1 | √ | null |
|
|
||
| is_unique_constraint | bit | 1 | √ | null |
|
|
||
| fill_factor | tinyint | 1 | null |
|
|
|||
| is_padded | bit | 1 | √ | null |
|
|
||
| is_disabled | bit | 1 | √ | null |
|
|
||
| is_hypothetical | bit | 1 | √ | null |
|
|
||
| is_ignored_in_optimization | bit | 1 | √ | null |
|
|
||
| allow_row_locks | bit | 1 | √ | null |
|
|
||
| allow_page_locks | bit | 1 | √ | null |
|
|
||
| using_xml_index_id | int | 4 | √ | null |
|
|
||
| secondary_type | char | 1 | √ | null |
|
|
||
| secondary_type_desc | nvarchar | 120 | √ | null |
|
|
||
| has_filter | bit | 1 | null |
|
|
|||
| filter_definition | nvarchar | 2147483647 | √ | null |
|
|
||
| xml_index_type | tinyint | 1 | √ | null |
|
|
||
| xml_index_type_description | nvarchar | 120 | √ | null |
|
|
||
| path_id | int | 4 | √ | null |
|
|
||
| auto_created | bit | 1 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
