Stored procedures can improve the performance of distributed applications by reducing the data traffic between server and client installations. Please note that you must register a stored procedure with the database before it can be called by a client program.
In DatabaseSpy, stored procedures that are registered with the database are displayed in a separate folder in the Online Browser. A context menu provides several maintenance options and, in addition, facilitates the creation of SQL statements for creating, altering, dropping, or executing the stored procedure (see Generating SQL Statements).
DatabaseSpy provides sub-folders for the procedures where the parameters are displayed. The definitions can be edited and renamed in the Properties window.
You can add stored procedures to the favorites, rename, or delete them. When deleting a stored procedure, a database structure change script is generated which must be executed in order for the deletion to take effect.