urSQL Utility

Features

• Currently supports MSSQL, MySQL, Paradox, *Oracle 8i, *MS Access, & **PostgreSQL (can also be connected to Interbase)
• SQL Syntax Highlighting (Customizable)
• SQL Code-Generator (Simple Queries) - Self Documenting!
• Easy-to-read Result-set Grid
• One-Click Access to Table Structure
• Unique Layout w/Access to Query,Tables, & Fields
• Supports Multiple Query Windows
• Database/Table Script Builder (MySQL, MSSQL, & MS Access)
• Export Query Results (Text, HTML, Etc.)
• MySQL Administrator Functions (Requires MySQL 3.22.xx or Higher)
• Customizable code templates
• Customizable auto-correct options
• MS SQL Stored Procedure support (view, alter, create)
• Column searcher
• Procedure searcher
• Self-documenting quick queries

Overview

The unique layout provides you with access to your query text at the same time you are viewing the a table and field list, allowing you to build complex queries without switching from window to window or consulting documentation.

Built-in options allow you to submit common queries with a single mouse click. Queries like, 'select * from sometable' are reduced to a click of the mouse. Other common query framework can be quickly created. Simple, but repetitive queries like 'insert into values(x,y,z,1,2,3)' and 'update where [field] = value' are easily created with a minimal amount of typing.

Complex INSERT/UPDATE query structures can be built with just a few clicks and the self-documenting feature makes the structure a snap to fill in. Great for working with web-based databases.

Expert SQL users will appreciate the time-saving benefits of this utility, after all it is designed to help enable developers. SQL novices can use the SQL code generation and shortcuts to learn the basics of Structured Query Language.