Visual SQL Query Builder
Visually create complex SQL queries
MyEclipse Standard Edition Feature
MyEclipse includes a Visual SQL Query Editor which you can
use to easily create complex SQL queries without having to
remember complex SQL syntax. Visually add tables, create joins,
manage groups, expressions and order your output with easy to
use wizards.
The editor can be opened from our existing SQL editor by
selecting
Open in MyEclipse Visual SQL Query Editor from the
context menu. On finish, the query you created will be inserted
into the SQL editor, replacing the selected query, if any.
MyEclipse Visual SQL Query Builder includes:
-
Ability to visuall create complex SQL statements
-
Ability to visually add tables, create joins, expressions
|
|
Getting Started
Working with the SQL Query Builder in MyEclipse begins with right-clicking on your SQL file, and going to Open With > MyEclipse Visual SQL Query Editor
You may also use the connection's context menu in the DB Browser
view.
Easily select tables to use in your query.
Example: creating a join is as simple as a mouse drag.
Including an expression result in your output, by selecting
Build Expression... from the Column combo.
Example of a finished query...
Resources
MyEclipse Innovations
The innovation and application of Eclipse technology is Genuitec's sole business. With well over 10 million downloads, our MyEclipse Enterprise Workbench product has grown to be the most popular and successful Eclipse-based JEE IDE. Our long chain of Eclipse technology innovation includes:
|
