Was this helpful?
Remove View Statement
The remove view statement removes from the Ingres Star catalogs view definitions that were registered using register view as link.
The remove view statement has the following format:
remove [view] [if exists] view_name
view
Is an optional object identifier. Whether or not you specify view, Ingres Star queries the local DBMS and determines the object type.
If you do not specify view, view_name is deleted whether the object is a table or a view. If view is specified, the object named must be a view.
if exists
Suppresses error reporting for the specified object if the object does not exist or exists but is not owned by you.
view_name
Is the registered Ingres Star name of the view. It can be delimited with double quotes.
Example: Remove View
To remove the registration of a view named usa_visits from your distributed database, use the statement:
remove view usa_visits;
Last modified date: 01/30/2023