RazorSQL Description:

Query, update, navigate and manage databases from one database client. RazorSQL ships with a relational database engine that requires no configuration. Connect to other databases via either ODBC or JDBC. Drivers are included for DB2, HSQLDB, Oracle, PostgreSQL, SQL Server, and Sybase. Run SQL scripts; visually edit, create, alter, and view tables; import and export data; build queries with the query builder; and browse database structures with the navigator. It also includes a tool to call stored procedures, a tool to compare table data and/or query results, query logging, and SQL templates for creating structures on several databases. The SQL programming editor includes support for SQL, PL/SQL, TransactSQL, SQL PL, and Java and includes auto column completion, auto function/method lookup, syntax highlighting, key-ahead, multi-tabular display of queries, find/replace, find/replace in files, and bracket matching. RazorSQL supports all major databases.
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
Execute / Execute Fetch All and Execute Batch functions
Multi-Tabular Display of Query Results
Query Logging
Key Ahead functionality for one-click population of user-defined text
File Compare Tool
Find, Find/Replace, Find/Replace in Files
Bracket Matching, Tag Matching, and Goto Line commands
File System Browser
Printing Support for Editor Content and Query Results
Built-in Relational Database:
Requires no end-user configuration
Get connected to a robust database right out of the box


Other Features:
Connect to any JDBC or ODBC (Windows only) compliant database. Built-in connectivity for DB2, HSQLDB, Microsoft SQL Server, Oracle, PostgreSQL, and Sybase
Built-in and Custom User Templates
Connection Keep-Alive
Plugin API (Allows users to add custom functionality to RazorSQL)
Visual Tools:
Create Table
Edit Table Data
Alter Table
Describe Table
View Table Content
Query Builder for Select, Insert, Update, and Delete Statements
Call Stored Procedure
Compare Table Data or Query Results
Import Table Data
Export Table Data
Database Meta Data Viewer (Functions, Types, etc.)


Database Navigator:
A tree structure to navigate database objects
Use user supplied queries for database navigation, or navigate the database structures using the default JDBC/ODBC driver settings or the included database specific queries
Single click content viewing on tables, views, etc.
Column information including column name, keys, data type, nullable information, etc.