Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| name | sysname | 256 | null |
|
|
|||
| object_id | int | 4 | null |
|
|
|||
| principal_id | int | 4 | √ | null |
|
|
||
| schema_id | int | 4 | null |
|
|
|||
| parent_object_id | int | 4 | √ | null |
|
|
||
| type | char | 2 | null |
|
|
|||
| type_desc | nvarchar | 120 | √ | null |
|
|
||
| create_date | datetime | 16,3 | null |
|
|
|||
| modify_date | datetime | 16,3 | null |
|
|
|||
| is_ms_shipped | bit | 1 | √ | null |
|
|
||
| is_published | bit | 1 | √ | null |
|
|
||
| is_schema_published | bit | 1 | √ | null |
|
|
||
| is_replicated | bit | 1 | null |
|
|
|||
| has_replication_filter | bit | 1 | null |
|
|
|||
| has_opaque_metadata | bit | 1 | null |
|
|
|||
| has_unchecked_assembly_data | bit | 1 | null |
|
|
|||
| with_check_option | bit | 1 | null |
|
|
|||
| is_date_correlation_view | bit | 1 | null |
|
|
|||
| is_tracked_by_cdc | bit | 1 | null |
|
|
|||
| has_snapshot | bit | 1 | null |
|
|
Relationships
Close relationships within degrees of separation
