|
|
Table Editor - Aqua Data Studio provides a Table Editor which allows a user
to graphically edit a resultset of a executed query. To activate a table editor you must write a single-table SELECT
statement and use the "Execute Edit" button. This will execute the query and return the resultset in a new Table Editor
window. From this window a user may edit the contents of the resultset and then save the changes.
The editor uses the primary key or any unique constraint to identify the row in the result it will generate UPDATE
statements for. If your resultset doesn't have a primary key or unique constraint, you will be prompted to define a
primary key in the primary key tab.
The editor allows you to add, edit and delete rows. The changes in the editor or color coded so that you may see your
changes before commiting the changes. Before saving you may clear any part of your changes. You may also preview the
changes that will be made in the 'Preview SQL' tab window, or save the SQL statements for the changes to a file.
|
|
|
