SQLMinus is an SQL Client with many developer-friendly features including::
- auto-linking across tables
- dependency discovery
- simple, intuitive and powerful keys to sort columns and filter data
- tab-completion of table and column names
- expansion of abbreviations (as in vi)
- expansion of previously entered words (as in vim)
- User may select tables and columns from combo lists and construct an SQL. Does auto-joining of fields, thus making SQL construction very easy
- preferences may be configured by user in file, or specified during session
- creation of create, insert, update script from table metadata
- creation of create index scripts by just selecting table and keys
- creation of other scripts (e.g. primary key) by just selecting table and columns
- allow user to add new script templates that will generate scripts on selecting tables and columns
- data presented in text format or tabular format (JTable). Multiple tables may be viewed
- Allows reflection of java.sql classes and the database meta data
- User may save command or output area to file and read the same from
a file
- User can run a batch command from a file. If the driver does not
support batched SQLs, then they would be issued individually
- User may define an SQL statement to be executed for multiple tables
(such as if a user wants to see the count of rows in many tables one
by one, or all data in a table one by one)
- Can auto-construct a query based on table/s and field/s selected in combo.
Will automatically create joins on identically named fields.
- One may specify links between tables in the ini file. When
auto-constructing an SQL, descriptive fields such as person_name or
dept_name will also be picked from the master table. See the ini
file for an example of a link.
See Other Best Database Clients Projects in Java:
7