SHOW PROCEDURES
From InterBase
Go Up to isql Command Reference
Lists all procedures or displays the text of a specified procedure.
SHOW {PROCEDURES | PROCEDURE name};
Argument | Description |
---|---|
<name> |
Name of an existing procedure in the current database |
Description: SHOW PROCEDURES
displays an alphabetical list of procedures, along with the database objects they depend on. Deleting a database object that has a dependent procedure is not allowed. To avoid an isql
error, delete the procedure (using DROP PROCEDURE
) before deleting the database object.
SHOW PROCEDURE
name displays the text and parameters of the named procedure.
SHOW PROCEDURE
has a shorthand equivalent, SHOW PROC
.
Examples: To list all procedures defined for the current database, enter:
SHOW PROCEDURES; Procedure Name Dependency Type ================= ==================== ======= ADD_EMP_PROJ EMPLOYEE_PROJECT Table UNKNOWN_EMP_ID Exception DELETE_EMPLOYEE DEPARTMENT Table EMPLOYEE Table EMPLOYEE_PROJECT Table PROJECT Table REASSIGN_SALES Exception SALARY_HISTORY Table SALES Table DEPT_BUDGET DEPARTMENT Table DEPT_BUDGET Procedure . . .
To display the text of the procedure, ADD_EMP_PROJ
, enter:
SHOW PROC ADD_EMP_PROJ;
Procedure text:
============================================================
BEGIN
BEGIN
INSERT INTO EMPLOYEE_PROJECT (EMP_NO, PROJ_ID) VALUES (:emp_no,
:proj_id);
WHEN SQLCODE -530 DO
EXCEPTION UNKNOWN_EMP_ID;
END
RETURN;
END
=================================================================
Parameters:
EMP_NO INPUT SMALLINT
PROJ_ID INPUT CHAR(5)