The remove statement removes registrations of tables, views, and database procedures from your distributed database. An object that is removed by the remove statement remains intact in the underlying local database, but is no longer identified to Ingres Star.

Local objects are registered by you with the register as link statement. You use the remove statement to remove these registrations. Only the registration is deleted. The local objects are not affected.

When you use the create table statement at the Ingres Star level, the table is automatically registered in your distributed database. You can use remove to delete these automatic registrations also. The underlying table remains.

You can execute the remove statement through dynamic SQL by the prepare/execute, and execute immediate statements.

The remove statement deletes only the registration residing in the Ingres Star catalogs. The table or view in the local DBMS is not affected.

You cannot remove an index with the remove statement.

You cannot remove a distributed view with the remove statement. You must use the drop statement to delete a distributed view.

The remove statement has the following forms:

If the type of object is not specified, Ingres Star assumes it is a table or view. The keyword procedure must be given to remove a procedure name.