Aqua data studio1/6/2024 ![]() 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. 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.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |