Data Editor Enables direct editing of table data. Insert, Update and Delete table data without writing any SQL statements. Supports direct editing of all standard JDBC data, including binary data types. Each data type has an editor specifically designed for it including a calendar for dates.
The data editor incorporates intelligent logic when editing foreign keys so that not only does it list only the valid key values, but it also determines the most likely description column as well. So you don't need to remember the foreign key values SQLCreator Professional will so show you what you need to know.
Binary data is treated as a first class citizen and updating it is simple, select a file, click OK and it will be inserted or updated as required, that's it.
Detail Pane Displays details on the selected database object in the Detail Pane and a detailed view of the child elements, with links to frequently used actions.
XML, HTML & RTF Export In addition to being able to export results as delimited text files, SQLCreator professional allows the export of query data in XML, HTML and RTF formats.
XML has become the standard format for information transfer in the internet age. SQLCreator professional has first class XML export facilities, enabling the export of XML with user defined tags, structuring the XML document how you need it.
The export of query results as HTML enables the publication of web documents directly from queries.
RTF is a well established document format supported by the majority of word processors and many text editors. RTF documents exported by SQLCreator can be imported into Microsoft Word, OpenOffice and many other word processors.
Statement Reformatting Allows reformatting of SQL statements, transforming an unformatted SQL statement into a well formatted and readable query. It is also possible to format a statement as a single line for insertion into application code, intelligently replacing single line comments with block comments so that the statement executes as expected.
Execute Selection / Execute Selection As Script Allows the execution of either part of a statement or a subset of many statements within an editor, executing only the text that is selected.
Centralised Administration Supporting shared database connection configurations. Allowing the central administration of connection configurations, so that changes only need to be made in one place and become available to everyone using them.
Different configurations can be defined for different teams defining only those those database connection that are relevant.
Personal connections can also be defined locally to augment the centrally defined connection definitions.
Split Editors SQLCreator Professional supports split editors, enabling the editing of statements and viewing of data side by side.
Compare Table Structures Comparison of table structures between different catalogs and schemas on the same or different databases.
Create Table / Create Index Dialogs Dialogs to simplify the creation of new tables or add indexes to existing tables.
