Run Stored Procedures and Functions

Running Stored Procedures and Functions

Procedures and functions stored in your database can be executed right from the Object Explorer. Once the procedure/function is executed, you can display the results in the Run Routines window. See Run Routines for more information.

To run a stored procedure

• Right-click a procedure/function and select Run

• If your procedure or function accepts parameters, you will be able to enter them before execution in the Set Input Parameters window

Snapshots

In Toad Edge, snapshots are a way of storing database structure (without data) as a readable JSON file. This file can be subsequently used as a create script source or as a Schema Compare source/target in Continuous Integration and Delivery (CI/CD).

There is also another type of snapshot - baseline snapshot. It is nearly identical to regular snapshot except it can be used in CI/CD in the Compare database with baseline build step. This build step will return an error if the database is different from the baseline snapshot. See Continuous Integration and Delivery Wizard for more information.

To take a snapshot of a database

1. In Object Explorer, right-click any database and select Take Snapshot
2. Change the snapshot name if you wish. Then click OK

Snapshots are stored in the Toad Edge folder structure. You can access the snapshot files in Snapshots View.

Templates

Templates are script snippets that can be reused in various editors. In Toad Edge, templates can be defined in three contexts:

• SQL - usable in Worksheet while working with all databases
• JSON - usable in JSON support and JSON Editor
• Database specific - such as MySQL - usable in Worksheet while working with the specific database

To configure templates

1. Go to Preferences (View menu | Preferences or press ALT + P)
2. Switch to the Templates tab. Here you can add/edit/remove templates

User Privilege Management