Database Stored Procedure Editor
The RazorSQL stored procedure editor allows users to edit stored procedures in various databases. At this time, RazorSQL supports editing procedures for the following databases:
DB2
Firebird
Informix
Ingres
MS SQL Server
MySQL
Oracle
SQL Anywhere
Sybase
The procedure editor is aware of syntax highlighting and function / system procedure information for Oracle PL/SQL, Sybase and MS SQL Server Transact-SQL, DB2 SQL PL, and MySQL.
The procedure editor retrieves the contents of the procedure from the database, and then generates the drop and create statements for the procedure. The editor provides function lookup, and auto table and column lookup. Shown below is an example image for a MS SQL Server stored procedure.