RazorSQL 4.1.0

Features automatic function/method lookup, automatic column lookup, key ahead, built-in and customizable templates. With the help of RazorSQL you can query, update, navigate, and manage all major databases from one database tool.
With RazorSQL, an SQL query tool, SQL editor, and database navigator, you can run SQL scripts, visually edit, create, alter, and view tables, import and export data, build queries with a query builder tool, and navigate databases with the database navigator. It even comes with a built-in relational database engine that requires no configuration.
The SQL programming editor has syntax highlighting for SQL, PL/SQL, TransactSQL, SQL PL, and Java, automatic function/method lookup, automatic column lookup, key ahead, built-in and customizable templates, multi-tabular display of query results, query logging, and many other features including a tool to call stored procedures and a tool to compare table and/or query data.
RazorSQL has been tested with virtually all popular databases, including MySQL, Oracle, DB2, Microsoft SQL Server, PostgreSQL, Microsoft Access, Pointbase, and Sybase.
Main features:
Advanced Connection Features
- A RazorSQL MySQL PHP Bridge for connecting to MySQL databases via a PHP page. Allows remote access to MySQL databases running behind PHP enabled web servers
- A RazorSQL JDBC Bridge for connecting to databases via a JEE/J2EE Application Server or Servlet Container
- Built-in support for DB2, HSQLDB, MySQL, Oracle, PostgreSQL, SQLite, SQL Server, and Sybase. Also can connect to any database that supports JDBC or ODBC
SQL Programming Editor
- Syntax Highlighting for SQL, PL/SQL, TransactSQL, SQL PL, Batch, C, CSS, C++, C#, Java, JavaScript, JSP, HTML, PHP, Perl, Python, Ruby, Shell Script, and XML
- Auto-function lookup for all supported programming languages and auto-method lookup for Java and JSP
- Automatic Column Lookup
- Automatic Table Lookup
- Execute, Execute Fetch All, and Execute Batch functions
- Multi-Tabular Display of Query Results
- Sortable Query Results
- Filterable Query Results
- SQL History for All Queries, and Query Logging Per Connection
- Key Ahead functionality for one-click population of user-defined text
- Find, Find/Replace, Find/Replace in Files
- Bracket Matching, Tag Matching, and Goto Line commands
- Printing Support for Editor Content and Query Results
- Built-in and Custom User Templates
- Connection Keep-Alive
- Plugin API (Allows users to add custom functionality to RazorSQL)
Tools
- Create Table / View
- Edit Table Data
- Alter Table
- Describe Table
- View Table Content
- Query Builder for Select, Insert, Update, and Delete Statements
- Create Stored Procedure, Function, Package
- Edit Stored Procedure, Function, Package
- View Stored Procedure, Function, Package
- Execute Stored Procedure
- Compare Table Data or Query Results
- File Compare Tool
- Zip Utility for viewing/extracting Zip and Jar files
- File System Browser
- Import Data
- Export Data
- Database Meta Data Viewer (Functions, Types, etc.)
- Explain Plan
Database Navigator
- A tree structure to navigate database objects
- Use RazorSQL provided database specific system queries or user supplied queries for database navigation, or navigate the database structures using the default JDBC/ODBC driver settings.
- Single click content viewing on tables, views, etc.
- Column information including column name, keys, data type, nullable information, etc.
- Displays information on objects such as procedures, functions, triggers, indexes, constraints, sequences, etc.
Built-in Database
- Requires no end-user configuration
- Get connected to a robust database right out of the box
- Uses the powerful HSQLDB database engine
Version restrictions:
- 30 days trial