Procedures
DbWrench procedures can be used to create SQL Server Stored Procedures and PostgreSQL Functions.
Note: MySQL Stored Procedures are not supported at this time, but will be shortly after MySQL v5.0 finishes beta and is available in general release.
Procedures can be created and edited by adding the procedure create code directly into the Source Code text panel.
The Procedure Name is uneditable and is parsed from the source code. This keeps the procedure name competely in sync with the name specified in the source code.
Below are a couple of Procedure examples.
PostgreSQL Procedure/Function Example
SQL Server (Stored) Procedure Example
Displaying Procedures Folder
The Procedures folder in Database Explorer is not displayed by default, since many database servers do not support procedures. To display the Procedures folder:
From the Edit menu select Preferences.
In the Preferences window select Database Explorer.
Ensure that the Show Procedure Folder checkbox is checked.
See also: