The remove procedure statement removes from the Ingres Star catalogs procedure definitions that were manually registered using register procedure as link.
The local DBMS procedure itself is not changed, but all the Ingres Star catalog definitions are deleted.
The remove procedure statement has the following format:
remove procedure procedure_name
Identifies the object as a database procedure
Is the registered Ingres Star name of the database procedure. It may be delimited with double quotes.
To remove the registration of a database procedure named west_prospects_proc from your distributed database, use the statement:
remove procedure west_prospects_proc;