Schema View Results
Schema view results is broken into two display sections, on the left is the tree list of database objects and the right is the details page.
Schema View Actions
Refresh |
Refresh reloads the entire schema and redisplays the details. |
Print a tree view style of schema report |
|
Snapshot |
Generate a snapshot of the current schema. This snapshot can then be used in a schema compare. See Snapshots |
Depends |
Generate a new Depends tab displaying objects that depend on the current object and object the current object depends upon. |
New Query |
Create a new query tab to generate your own queries. These queries can be DML or DDL style queries. |
Queries
An important feature of Schema View projects is the ability to execute SQL queries on the server. These queries can return data using a SELECT statement or update the schema using DML statements like ALTER.
The query is by default executed against the selected server and database.
Multiple queries can be executed however generally the first results is shown. SQL Delta doesn't currently support displaying multiple result sets.
To execute the query either press F6 or the Run Query button. Most of the editor features shown in the Schema Compare Script window also apply to this script window such as toggling comments or bookmarks.
To display the auto complete press Ctrl + Space.
Many query tabs can be created per schema view, just click the New Query button or press Ctrl + N.
Data Display
The data tab automatically generates a select statement for tables or views and sends the query to the server. The data is load once and must be manually refreshed by clicking the refresh button. If multiple tables are selected the data is scheduled for loaded and the data grid populated as the data arrives.
Rows - Number of rows to load, press the Filter button to switch off the row limiter.
Refresh - Reloads the data after the initial load. Switch tabs or from one table to another doesn't reload the data.
Menu - Copy the selected cell or selected row to the clipboard.