Feature TourFeature Tour

Procedure, Function, Package and Trigger

Previous Next

DbVisualizer include support for PL (procedural language) objects such as procedures, functions, packages and triggers. Objects of this type can be created, edited, compiled (when appropriate) and executed.

 

                  
This screenshot show the action used to create a
stored procedure in a SQL Server database.
Create Procedure

                  
Click a procedure in the database browser and the Procedure Editor is
activated in the object details pane.
Edit Procedure

                  
Clicking Execute in the Procedure Editor executes the procedure in the 
SQL Commander and prompts for IN/INOUT parameters. The return value and 
OUT/INOUT parameter values are written to the log.
Execute Procedure

                  
The Create Trigger action dialog lets you visually define a new trigger
Create Trigger
Feature DbVisualizer
Pro
DbVisualizer
Free
» Create Procedure, Function, Package, Trigger
» Edit Procedure, Function, Package, Trigger
» Execute Procedure, Function