Name: | NICK_COLUMNS |
Schema: | USER |
Wrapper: | CONNECT |
Remote server: | TEST |
Remote schema: | SYSIBM |
Remote table: | COLUMNS |
Readonly: | |
Cached: | |
Materialised view: | |
Status: | NORMAL |
Create time: | 01.07.2006 |
Description: |
Name | Type | Length | Scale | Codepage | Identity | Nulls | Default | Description | |
|
TABLE_CATALOG | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
TABLE_SCHEMA | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
TABLE_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
COLUMN_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
ORDINAL_POSITION | INTEGER | 4 | 0 | 0 |
|
|
||
|
COLUMN_DEFAULT | VARCHAR | 2000 | 0 | 1251 |
|
|
||
|
IS_NULLABLE | VARCHAR | 3 | 0 | 1251 |
|
|
||
|
DATA_TYPE | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
CHARACTER_MAXIMUM_LENGTH | INTEGER | 4 | 0 | 0 |
|
|
||
|
CHARACTER_OCTET_LENGTH | INTEGER | 4 | 0 | 0 |
|
|
||
|
NUMERIC_PRECISION | INTEGER | 4 | 0 | 0 |
|
|
||
|
NUMERIC_PRECISION_RADIX | INTEGER | 4 | 0 | 0 |
|
|
||
|
NUMERIC_SCALE | INTEGER | 4 | 0 | 0 |
|
|
||
|
DATETIME_PRECISION | INTEGER | 4 | 0 | 0 |
|
|
||
|
INTERVAL_TYPE | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
INTERVAL_PRECISION | INTEGER | 4 | 0 | 0 |
|
|
||
|
CHARACTER_SET_CATALOG | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
CHARACTER_SET_SCHEMA | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
CHARACTER_SET_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
COLLATION_CATALOG | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
COLLATION_SCHEMA | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
COLLATION_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
DOMAIN_CATALOG | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
DOMAIN_SCHEMA | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
DOMAIN_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
UDT_CATALOG | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
UDT_SCHEMA | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
UDT_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
SCOPE_CATALOG | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
SCOPE_SCHEMA | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
SCOPE_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
MAXIMUM_CARDINALITY | INTEGER | 4 | 0 | 0 |
|
|
||
|
DTD_IDENTIFIER | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
IS_SELF_REFERENCING | VARCHAR | 3 | 0 | 1251 |
|
|
Name | Unique rule | Type | Colnames | Description | |
|
USER.CC1151754616344 | PRIMARY | REGULAR | TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME |
Name | Valid | Text | |
|
CC1151754626766 |
|
TABLE_SCHEMA is not null |
Grantor | Grantee | Authorities | |
|
SYSIBM | USER | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
See Also
List of nicknames