Drop View Statement
The drop view statement has the following format:
drop [table] view_name
Use this statement to remove a distributed view created by the create view statement at the Ingres Star level. It removes the description of the view from the Ingres Star catalog. It does not affect the underlying data on which the view is defined.