FairCom Java & .NET Stored Procedures

Modifying and Deleting Stored Procedures

There is no “ALTER PROCEDURE” statement. To modify a procedure, you will need to drop and recreate it. To recreate the procedure, you need the original source of the CREATE PROCEDURE statement. Before you drop the procedure, decide which approach you will use to recreate it:

• If you kept the original procedure definition in an FairCom DB SQL script file, simply edit the file and resubmit it through interactive SQL.
• Query system tables to extract the source of the CREATE PROCEDURE statement to a file.

The FairCom DB SQL DROP PROCEDURE statement deletes stored procedures from the database. Exercise care in dropping procedures, since any procedure that calls the dropped procedure will fail.