Name: | QQQ_STAFF |
Schema: | USER |
Wrapper: | CONNECT |
Remote server: | TEST |
Remote schema: | USER |
Remote table: | STAFF |
Readonly: | |
Cached: | |
Materialised view: | USER.QQQ_STAFF_MQT |
Status: | NORMAL |
Create time: | 01.07.2006 |
Description: |
Name | Type | Length | Scale | Codepage | Identity | Nulls | Default | Description | |
|
ID | SMALLINT | 2 | 0 | 0 |
|
|
||
|
NAME | VARCHAR | 9 | 0 | 1251 |
|
|
||
|
DEPT | SMALLINT | 2 | 0 | 0 |
|
|
||
|
JOB | CHARACTER | 5 | 0 | 1251 |
|
|
||
|
YEARS | SMALLINT | 2 | 0 | 0 |
|
|
||
|
SALARY | DECIMAL | 7 | 2 | 0 |
|
|
||
|
COMM | DECIMAL | 7 | 2 | 0 |
|
|
Name | Unique rule | Type | Colnames | Description | |
|
USER.CC11517556264221 | PRIMARY | REGULAR | ID |
Table | Foreign key | Primary key | |
|
USER.ACT | CC1152703301094 | PK_ACT |
Name | |
|
USER.QQQ_STAFF_MQT |
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