SQL command reference

This section describes the Netezza Performance Server SQL commands that relate to the creation and management of stored procedures.

The following table lists the SQL commands.

Table 1. Stored procedure SQL commands
Command Description More information
ALTER PROCEDURE Changes a stored procedure. The ALTER PROCEDURE command.
CALL or EXEC[UTE [ PROCEDURE]] Runs a stored procedure. The CALL and EXEC[UTE [PROCEDURE]] commands
CREATE [OR REPLACE] PROCEDURE Adds or updates a stored procedure. The CREATE [OR REPLACE] PROCEDURE commands.
DROP PROCEDURE Drops or deletes a stored procedure. The DROP PROCEDURE command.
SHOW PROCEDURE Displays information about stored procedures. The SHOW PROCEDURE command.