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 |
|
|
|||
max_readers | smallint | 2 | √ | null |
|
|
||
activation_procedure | nvarchar | 1552 | √ | null |
|
|
||
execute_as_principal_id | int | 4 | √ | null |
|
|
||
is_activation_enabled | bit | 1 | null |
|
|
|||
is_receive_enabled | bit | 1 | null |
|
|
|||
is_enqueue_enabled | bit | 1 | null |
|
|
|||
is_retention_enabled | bit | 1 | null |
|
|
|||
is_poison_message_handling_enabled | bit | 1 | √ | null |
|
|