Previous Topic

Next Topic

Drop Statement

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.

Previous Topic

Next Topic

Drop Table Statement

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.

Previous Topic

Next Topic

Example: Drop Table

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";

Previous Topic

Next Topic

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.


© 2007 Ingres Corporation. All rights reserved.