4. Managing Tables and Views : Views : Working with View Objects
 
Share this page                  
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.