Name: | VHDEPT |
Schema: | USER |
Definer: | USER |
Readonly: | |
Valid: | |
Qualifier: | USER |
Description: |
Name | Type | Length | Scale | Codepage | Nulls | Description | |
|
DEPTNO | CHARACTER | 3 | 0 | 1251 |
|
|
|
DEPTNAME | VARCHAR | 29 | 0 | 1251 |
|
|
|
MGRNO | CHARACTER | 6 | 0 | 1251 |
|
|
|
ADMRDEPT | CHARACTER | 3 | 0 | 1251 |
|
|
|
LOCATION | CHARACTER | 16 | 0 | 1251 |
|
Name | |
|
USER.DEPARTMENT |
|
USER.DEPT |
Grantor | Grantee | Authorities | |
|
SYSIBM | USER | CONTROL=HELD, ALTER=NOT_HELD, DELETE=HELD_GRANTABLE, INDEX=NOT_HELD, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=NOT_HELD, UPDATE=HELD_GRANTABLE |
CREATE VIEW VHDEPT AS SELECT ALL DEPTNO , DEPTNAME, MGRNO , ADMRDEPT, LOCATION FROM DEPT
See Also
List of views