SQL query
- All databrowser grid functions
+
- Run SQL statements.
- More result in one window.
- Syntax highlighting word processor.
- Content of the Word processor can be saved to file and reloaded.
- Semigraphic design of SQL statements (SELECT, INSERT, UPDATE, DELETE).
- The result appears in a table or text format.
- Build SQL statements from result.
- Build SQL statement.
- Paste table / field / SQL scalar.
- SQL specific functions.
- Command history: Previous / next command.
|
|
|
Data browser
- Table data retrieval.
- Result can be filtered and ordered.
- Export one result as table
- Export the results of SQL queries into an arbitrary table of a different database type.
- Export into a new table or add the export results to the rows of an existing one.
- Prepared statements / SQL statements.
- Advanced datatype conversion.
- Export structure and data.
- Operations: execute, copy to clipboard, save to file.
- Export one result as text
- Save the results of SQL queries into text, CVS, fixed length or HTML file.
- Operations: copy to clipboard, save to file.
- The result of SELECT statement can be updated on the spot.
- Optimized memory management. The memory will not be fulfilled even in case of queries containing millions of rows, because SQL Uniform stores the results in quickly accessible temporary files.
- Copy SQL statements (SELECT, INSERT, UPDATE, DELETE) to clipboard appointed by the actual row based on the result set.
- Row limit parameter.
- Find and replace in the result.
- Quick filter.
- Sum expression.
- Set to null.
- Delete record.
- Commit / rollback.
|
|
|
Data comparison
- Comparison of data in database tables, even between different types of databases.
- Comparison of results of any SELECT statements.
- Selection of rows with the same key but different data content.
- Selection of double-key rows.
- Find identifiers that not exist in other result set.
- Compare tables / result of SQL statements / SQL Query window results / Data Browser window results.
- Automatic unique key recognition.
- Column expressions.
- Without sorting, the identifier is the row number parameter.
- Null equals empty string parameter.
- Null equals zero in numbers parameter.
- Ignore case in strings parameter.
- Trim / right trim strings parameter.
- Compare date fields with second precision parameter.
- Compare date fields with day precision parameter.
|
|
|
Export (convert)
- Export more database table together.
- Prepared statements / SQL statements.
- Advanced datatype conversion.
- Export structure and data.
- Operations: execute, save to file.
- Where clause.
- Insert / Update / If not exists insert / If not exists insert else UPDATE parameter.
- Type conversion rules.
|
|
|
SQL import
- Mode of executing and handling of SQL statements parameters.
|
|
|
Design table
- Different level of implementation by database type. Standard implementation allow table and index level maintenance, advanced implementation may also contain the handling of check, trigger, view, primary key, foreign key, constraint, stored procedure.
- Supports every type of database at least on basic level by creating table and index, updating structure and dropping it.
- SQL script.
- SQL CREATE script.
- Modify with data moving parameter.
|
|
|
Administration
- Database (catalog), owner (schema), table, view, stored procedure information.
- Datatype information.
- Database information.
- Table design.
- Create table.
- Create table based on selected.
- Alter table.
- Show count(*).
- Drop table.
- Delete rows from table.
- Rename table (SQL server specific).
- Create view (SQL server specific).
- Alter view (SQL server specific).
- Drop view (SQL server specific).
- Quick selection.
|
|
|
Platform
- The application may be equally used under Windows, Linux, Unix, Mac OS, OS2 and Solaris as well as all kinds of operation systems, where 1.4.1 version of Java runtime environment can be installed.
|
|
|
Connection:
- Help on connection for more than 20 sorts of database (Access, Adabas D, DaffodilDB, dBASE, Excel, HSQLDB, IBM Cloudscape, IBM DB2, Interbase (Firebird), InterSystems Caché, JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Quadcap QED, Solid, SQLITE, StelsCSV, Sybase, ThinkSQL, Yard).
- Connection to any kind of database through JDBC or ODBC standard drivers.
- You can browse the data of several various types of database at the same time.
- Dynamic driver load. You do not have to set the CLASSPATH environment variable, you simply have to enter the access path of the installed driver.
- Default connection parameter.
- Save encrypted password parameter.
- Charset parameter.
- Use the same connection if possible parameter.
- Transaction isolation level parameter.
- Auto-commit mode parameter.
|
|
|
