Working with View Objects
You can perform the following basic operations on views:
• Create view objects
• View existing view objects, including details such as the view definition, grantees, and rows
• Drop view objects
In SQL, you can accomplish these tasks using the SQL statements CREATE VIEW, HELP VIEW, and DROP VIEW. For details, see the SQL Reference Guide.
In Director or VDBA, use the Views branch for a particular database.
Note: To drop a view the cache size that was needed to create the view must be enabled.