Aqua data studio key update#
Aqua data studio key full#

This helps the display the full value of a narrow cell, including long string values or CLOB values. The Preview Panel creates a cell's preview in a split panel to allow the user to preview the currently selected value in the grid. The Messages tab displays any warnings or messages during table data modification.ДЄt the bottom of the Table Data Editor window are the Preview Panel (when enabled) and Status Bar. The Preview SQL tab displays the DDL used to perform the edits made within the Table Data Editor with appropriate Syntax highlighting. If more than one table was used in the query, a dialog appears to choose the primary keys and an additional Primary Key tab will display for each table with schema information in the tab title. The Primary Key tab displays a list of all of the columns relating to the tables in the query used to launch the Table Data Editor via the Execute Edit command from the Query Analyzer. This option can be configured from the dropdown menu. Using Edit->Format: AutoFit Column Width, cells can be highlighted and resized automatically using the menu, a key shortcut, or a double-click on the right border of the column header.

Table Columns, must be added or removed from tables via context menus with right clicks in the Schema Browser or through the Query Analyzer by way of database commands. A box appears around the content inside of a selected cell to identify content length where blank spaces may appear before text, but not be visible. Row color and bolding assist in displaying recent changes and nulls in the data, and appear in the Table Data Editor modification logs (when enabled in File->Options->Table Editor->Modification Logs).

Most of the work done in the Table Data Editor occurs in the Table Data tab, which displays the data for the table(s) from the select statement used in the Execute Edit mentioned earlier. The layout of the data within the Table Data tab functions similar to a spreadsheet appliction, with the ability to insert rows and cells where desired via Find and Replace when needed. The Window menu can be used to cycle through tabs when so many exist it is difficult know which one was focus via Window->Next Tab Window->Previous Tab Window->Focus Max Results. Below are Toolbar icons for Refresh, Reconnect, Save and Refresh, Save and Close, Save Script ('Save Script' stores the chosen directory path and uses it for subsequent save operations as a default directory for easier navigation), Stop, Add Row Above, Add Row Below, Clone Selected Row(s), Clear All Changes, Clear Selected Deleted Rows, Clear Changes in Selected Cells, Set Cells to Null, INSERT Current Date and Time, INSERT Current Date Only, Edit in Window, Close Window, Max Results, Aggregate Functions (when enabled) and Quick Filter.Д«elow the Toolbar Icons are the tabs for Table Data, Primary Key, Preview SQL and Messages. Their functionality for refreshing and reconnecting to database servers has been included to make it easier to reconnect and refresh table data without having to access the Main Application Menus and Toolbar.ДЄt the top are the File, Edit and Window menus. The Table Data Editor's menus and icons are taken directly from the Main Application Toolbar. The window for the Table Data Editor can remain open as other tools in Aqua Data Studio are used. Like the other tools of Aqua Data Studio, the Table Data Editor is part of the Application Docking Framework. There is an option within File->Options->Permissions to allow Primary Key Definition Changes. A check mark indicates which column(s) participate in the primary key. 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.

Aqua data studio key update#

The editor uses the primary key or any unique constraint to identify the row in the result which it will generate UPDATE statements for. From this window a user may edit and save the contents of the resultset. This will execute the query and return the resultset in a new Table Editor window. To activate a table editor you must either right click on a table in the Schema Browser and select 'Edit Table Data (Top 1000)' or write a table SELECT statement and use the 'Execute Edit' button. The editable result set is displayed in an Excel like grid. Aqua Data Studio provides a Table Data Editor which allows a user to graphically edit the resultset of an executed query on a table, including its data and rows.