The SQL History tab displays only the number of entries set by the Max History value. The Quickfilter allows live filtering of the contents of the History grid.īelow these buttons and form fields are tabs for SQL History and SQL Archive. Auto Archive automates the archiving process. Max Statements per Entry limits the number of statements an individual item in the history can contain. The Max History input field sets the number of items visible before storing to the archive. Copy Compare launches the comparison tool for selected items. Save Script takes the currently selected item and prompts the user to save it with a file name. Archive All writes all of the displayed contents of the SQL History to the SQL Archive. Archive Selected places the current item in the SQL History Archive. Delete All deletes all of the contents of the SQL History. Delete Selected deletes the current item in the SQL History. The Select and Close button does the same, but closes the History after writing the item to the Main Application Window. The Select button writes the currently selected item into the current tool in the Main Application Window. The SQL History and SQL History Archive display history items in a window with buttons for Select, Select and Close, Delete Selected, Delete All, Archive Selected, Archive All, Save Script, Toggle Preview, Close, Copy Compare, Max History, Max Statements per Entry, Auto Archive checkbox and the Quickfilter. If the ’Max Statements Per Entry’ is set to 5 and a script of 100 statements are executed only the first five would be stored with that entry. The ’Max Statments Per Entry’ sets the maximum number of statments stored in a history entry. The ’Max History’ sets the maximum number of SQL commands stored in the history. The SQL History window provides a list of previously executed statements from which to choose a query. The history window does not need to be closed to continue working on your queries, and may run side-by-side with the main window. The SQL History dialog can be activated by clicking on the SQL History toolbar button. To view detailed SQL Logs captured from all areas of Aqua Data Studio, see the SQL Log page. Double clicking on an SQL History item writes it into the current tool for reexecution or editing. Aqua Data Studio includes an SQL History, and SQL History Archive which provides a history of all SQL statements and scripts that have been executed within the Query Analyzer, Query Builder, Table Data Editor and SQL Debuggers.
0 Comments
Leave a Reply. |