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.
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. |