Name: | NICK_CHECK_CONSTRAINTS |
Schema: | USER |
Wrapper: | CONNECT |
Remote server: | TEST |
Remote schema: | SYSIBM |
Remote table: | CHECK_CONSTRAINTS |
Readonly: | |
Cached: | |
Materialised view: | |
Status: | NORMAL |
Create time: | 01.07.2006 |
Description: |
Name | Type | Length | Scale | Codepage | Identity | Nulls | Default | Description | |
|
CONSTRAINT_CATALOG | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
CONSTRAINT_SCHEMA | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
CONSTRAINT_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
CHECK_CLAUSE | CLOB | 2097152 | 0 | 1251 |
|
|
Name | Unique rule | Type | Colnames | Description | |
|
USER.CC1151754705266 | PRIMARY | REGULAR | CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME |
Name | Valid | Text | |
|
CC1151754741688 |
|
CONSTRAINT_NAME is not null |
Name | |
|
USER.AAAAAAAAAAAA |
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