Name: | NICK_STAFF_MQT |
Schema: | USER |
Cached schema: | USER |
Cached table: | USER.NICK_STAFF |
Tablespace: | NICK_STAFF_MQT_TS |
Definer: | USER |
Readonly: | |
Valid: | |
Qualifier: | USER |
Description: |
Name | Type | Length | Scale | Codepage | Nulls | 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 | |
|
USER.NICK_STAFF |
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 |
CREATE TABLE USER.NICK_STAFF_MQT AS (SELECT * FROM "USER".NICK_STAFF) DATA INITIALLY DEFERRED REFRESH DEFERRED MAINTAINED BY FEDERATED_TOOL IN NICK_STAFF_MQT_TS
See Also
List of materialised views