Re: Stored procedures

In dbaccess, try the following query: select procname from sysprocedures where procname =<your_procedure_name_in_quotes> To see the actual procedure code (if it exists), type this from the command line: dbschema -d <your_database> -f <your_procedure_name> -mka Hi folks ! I wounder how to find out if a stored procedure exist in the current database, i've looked thru all tables in sysmaster database, i did found one named sysprc, but that didn't seam to be the right one.