Properties

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

Columns

	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

Total: 4 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 VDEPT      AS SELECT ALL DEPTNO,   DEPTNAME,   MGRNO,   ADMRDEPT FROM DEPT

See Also

List of views