Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| object_id | int | 4 | null |
|
|
|||
| name | sysname | 256 | √ | null |
|
|
||
| parameter_id | int | 4 | null |
|
|
|||
| system_type_id | tinyint | 1 | null |
|
|
|||
| user_type_id | int | 4 | null |
|
|
|||
| max_length | smallint | 2 | null |
|
|
|||
| precision | tinyint | 1 | null |
|
|
|||
| scale | tinyint | 1 | null |
|
|
|||
| is_output | bit | 1 | null |
|
|
|||
| is_cursor_ref | bit | 1 | null |
|
|
|||
| has_default_value | bit | 1 | null |
|
|
|||
| is_xml_document | bit | 1 | null |
|
|
|||
| default_value | sql_variant | 8000 | √ | null |
|
|
||
| xml_collection_id | int | 4 | null |
|
|
|||
| is_readonly | bit | 1 | null |
|
|
|||
| is_nullable | bit | 1 | √ | null |
|
|
||
| encryption_type | int | 4 | √ | null |
|
|
||
| encryption_type_desc | nvarchar | 128 | √ | null |
|
|
||
| encryption_algorithm_name | nvarchar | 256 | √ | null |
|
|
||
| column_encryption_key_id | int | 4 | √ | null |
|
|
||
| column_encryption_key_database_name | sysname | 256 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
