Edit Database Views and Stored Procedures
Intuitive Editing Features:
- Auto-generate SQL create and alter scripts for views and procedures
- Edit existing database views and stored procedures
- Create new database views and stored procedures
- Create or edit user defined functions
- Copy and paste between multiple open editor windows
- Save and reload SQL scripts
The DatabaseSpy® 2017 Online Browser and SQL Editor combine to provide a powerful toolset for editing database views and stored procedures. The DatabaseSpy Online Browser lets you explore views and procedures by navigating and expanding them the same way you can explore tables in the hierarchical display of the Online Browser helper window. A right-click context menu offers options to generate new statements in the SQL Editor that can quickly get you started editing a view, or to assist creating a new one.
When you generate a create statement for an existing view, DatabaseSpy displays the formatted and color-coded view definition for immediate access in a new SQL Editor window. You can modify the statement any way you like in the SQL Editor. As an example, let’s assume you’ve been assigned to create a company phone directory view. All the data you need is already contained in the employees view – plus a lot more!
You can revise the existing view to make the changes you want, taking advantage of all the DatabaseSpy SQL Editor functionality, including color coding, automatic formatting, and even auto-completion. When your edits are complete, the SQL Editor Execute button runs the statement and modifies the view in the database.
Create a New Database View
If you don’t have an existing view to use as a template, DatabaseSpy offers a convenient alternative. The SQL Refactoring menu includes an option to convert any select query to a create view statement. The default view name is even highlighted so you can immediately assign a new name if you like.
Edit and Execute Procedures
The Online Browser also lets you edit stored procedures in your database. You can highlight any stored procedure, then can expand your selection to explore it. Or, use the right-click context menu to generate SQL statements for operations available to act on stored procedures.
You can edit stored procedures in the SQL Editor and execute your revised statements using the same techniques described for database views.
The Execute option in the DatabaseSpy context menu for stored procedures builds a time-saving template for an execution script for the stored procedure. For procedures that require parameters, all you have to do is set the parameter values, then it’s just one click to execute the stored procedure and view the results.
- Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
- Oracle® 9i, 10g, 11g, 12c
- MySQL® 5, 5.1, 5.5, 5.6
- IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
- IBM DB2 for iSeries® v6.1, 7.1
- Informix® 11.70
- Sybase® ASE 15
- Microsoft Access™ 2003, 2007, 2010, 2013
- SQLite 3.x
- Firebird 2.5
- Progress OpenEdge 11.6
Edit User-defined Functions
DatabaseSpy even lets you navigate and edit user-defined functions stored in your database, starting from the same convenient right-click context menu in the Online Browser.