Use the drop statement to remove tables and views from your distributed and local databases. You may only drop an object (table or view) that was created in Ingres Star.
The drop table statement has the following format:
drop [table] table_name
Use this statement on table objects created by the create table statement at the Ingres Star level. It removes the actual table, its registration, and all its data, as well as the description of the table in the Ingres Star catalogs.
Important! Use the drop statement with care because this statement destroys objects. All dependent objects, for example, views and indexes, are also dropped.
To remove the registration of corp_dept from the distributed database and the table itself from the local database, west_usa, use the following command:
drop table corp_dept;
To drop the table named World Wide Sales, delimit the table name:
drop table "World Wide Sales";
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.