The drop statement removes objects from the distributed database. Only objects created through Ingres Star can be dropped.

Whenever you use the drop statement, you always drop the registration and the underlying locally-stored object. For example, if you use the drop table statement, the underlying table and its data are destroyed. When an Ingres Star-level object is deleted with the drop statement, all views on it also are recursively dropped.

The drop link statement is provided for compatibility with earlier versions of Ingres Star.

The drop table statement removes tables from the distributed database. Any underlying table in a local database also is dropped.

The drop view statement removes Ingres Star-level views from the distributed database.