Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TABLE_CATALOG | nvarchar | 256 | √ | null |
|
|
||
| TABLE_SCHEMA | nvarchar | 256 | √ | null |
|
|
||
| TABLE_NAME | sysname | 256 | null |
|
|
|||
| COLUMN_NAME | sysname | 256 | √ | null |
|
|
||
| ORDINAL_POSITION | int | 4 | null |
|
|
|||
| COLUMN_DEFAULT | nvarchar | 8000 | √ | null |
|
|
||
| IS_NULLABLE | varchar | 3 | √ | null |
|
|
||
| DATA_TYPE | nvarchar | 256 | √ | null |
|
|
||
| CHARACTER_MAXIMUM_LENGTH | int | 4 | √ | null |
|
|
||
| CHARACTER_OCTET_LENGTH | int | 4 | √ | null |
|
|
||
| NUMERIC_PRECISION | tinyint | 1 | √ | null |
|
|
||
| NUMERIC_PRECISION_RADIX | smallint | 2 | √ | null |
|
|
||
| NUMERIC_SCALE | int | 4 | √ | null |
|
|
||
| DATETIME_PRECISION | smallint | 2 | √ | null |
|
|
||
| CHARACTER_SET_CATALOG | sysname | 256 | √ | null |
|
|
||
| CHARACTER_SET_SCHEMA | sysname | 256 | √ | null |
|
|
||
| CHARACTER_SET_NAME | sysname | 256 | √ | null |
|
|
||
| COLLATION_CATALOG | sysname | 256 | √ | null |
|
|
||
| COLLATION_SCHEMA | sysname | 256 | √ | null |
|
|
||
| COLLATION_NAME | sysname | 256 | √ | null |
|
|
||
| DOMAIN_CATALOG | sysname | 256 | √ | null |
|
|
||
| DOMAIN_SCHEMA | sysname | 256 | √ | null |
|
|
||
| DOMAIN_NAME | sysname | 256 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
