Altova DatabaseSpy 2024 Professional Edition

If the currently connected database supports and contains stored procedures, these are displayed by default in the "Procedures" folder in the Online Browser.

dbs_stored_procedures

The DatabaseSpy icons associated with stored procedures are as follows:

 

ds_ic_stored_procedure

Stored procedure

ds_ic_para_in

Input parameter

ds_ic_para_inout

Input output parameter

ds_ic_para_out

Output parameter

ds_ic_para_ret

Return parameter

 

To reveal various options for maintaining stored procedures, right-click the procedure in the Online Browser and select the required command from the context menu. The commands grouped under Show in new SQL Editor enable you to generate SQL statements for creating, altering, dropping, or executing the stored procedure.

 

When renaming or dropping a stored procedure, a script is generated in the Database Structure Change Script Window. The script must be executed in order for the changes to take effect.

© 2017-2023 Altova GmbH