Tuesday, December 14, 2010

List all stored procedures in a Firebird database

Following SQL query gives you all the user define stored procedures in a Firebird database.

SELECT rdb$Procedure_name as "Procedure Name" FROM rdb$procedures
WHERE rdb$system_flag IS NULL OR rdb$system_flag = 0;

1 comment:

Rohan Ramesh said...

Sanjay ,
How can you extract a stored procedure from Firebird database