sqlFree gives you the opportunity to build your SQL-statements.
sqlFree gives you the opportunity to build your SQL-Statements visually as known from MS-Access. Parsing and visualizing statements also is supported. The statements can also be sent to a DB and returned results viewed. Use the JDBC-driver you like.
New:
Support for statement types (Select, Insert, Delete, Update)
supported join types (inner, left, right, self)
Meta-information available for inspection: Primary key, nullable, datatype etc.
Generation optionally includes schemanames into the built SQL-statements
Uses metainformation for generation. Example: if datatype information is available values automatically are quoted.
ability to visualize DB-stored relationinformation - only for displayed tables as well as for all tables (think of displaying a datamodel) - of course this information has to be provided by the database
Supports tablenames with whitespaces
For layouting issues fontsizes of your tables can be specified
No syntax-errors in queries
You see that your queries do what they are intended to do. This especially is an advantage in bigger queries.
Generates Readable layouted SQL statements
Easier and FASTER than writing by hand. Just think of queries having a few joins, criteria, sorting clauses and all the other stuff. you can free download SqlFree 5.01 now.