Procedures
DbWrench procedures can be used to create SQL Server Stored Procedures and PostgreSQL Functions.
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 in sync with the name specified in the source code.
Note: If the procedure/function has it's comment defined within the source code, as MySQL does, then the 'Comment' text field will always be kept in sync with the comment defined in the source code section. Users should edit the comment in the source definition.
Below are a couple of Procedure examples.
PostgreSQL Procedure/Function Example
SQL Server (Stored) Procedure Example
See also: