Properties

Name: VHDEPT 
Schema: USER 
Definer: USER 
Readonly:  
Valid:  
Qualifier: USER 
Description:  

Columns

Name Type Length Scale Codepage Nulls Description
  DEPTNO  CHARACTER  1251     
  DEPTNAME  VARCHAR  29  1251     
  MGRNO  CHARACTER  1251     
  ADMRDEPT  CHARACTER  1251     
  LOCATION  CHARACTER  16  1251     
Total: 5 column(s)

Depend on objects

Name
  USER.DEPARTMENT 
  USER.DEPT 
Total: 2 object(s)

Autherisations

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 
Total: 1 autherisation(s)

SQL

CREATE VIEW VHDEPT    AS SELECT ALL DEPTNO ,   DEPTNAME,   MGRNO ,   ADMRDEPT, LOCATION   FROM DEPT

See Also

List of views