Name: | NICK_REFERENTIAL_CONSTRAINTS |
Schema: | USER |
Wrapper: | CONNECT |
Remote server: | TEST |
Remote schema: | SYSIBM |
Remote table: | REFERENTIAL_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 |
|
|
||
|
UNIQUE_CONSTRAINT_CATALOG | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
UNIQUE_CONSTRAINT_SCHEMA | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
UNIQUE_CONSTRAINT_NAME | VARCHAR | 128 | 0 | 1251 |
|
|
||
|
MATCH_OPTION | VARCHAR | 4 | 0 | 1251 |
|
|
||
|
UPDATE_RULE | VARCHAR | 9 | 0 | 1251 |
|
|
||
|
DELETE_RULE | VARCHAR | 9 | 0 | 1251 |
|
|
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