Remove Procedure Statement
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
procedure
Identifies the object as a database procedure
procedure_name
Is the registered Ingres Star name of the database procedure. It can be delimited with double quotes.
Example: Remove Procedure
To remove the registration of a database procedure named west_prospects_proc from your distributed database, use the statement:
remove procedure west_prospects_proc;
Last modified date: 11/09/2022