Was this helpful?
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.
Drop Link
The drop link statement is provided for compatibility with earlier versions of Ingres Star.
Drop Table
The drop table statement removes tables from the distributed database. Any underlying table in a local database also is dropped.
Drop View
The drop view statement removes Ingres Star-level views from the distributed database.
Last modified date: 01/30/2023