Integrated VS Classic View
Starting from WinSQL 6.5, users have an option of displaying the catalog information right next to the
query window. This type of layout is called as Integrated View
. Users can display catalog, query and results all
together in Integrated View.
You can drag table and field names from the Catalog tree into the query window. In most cases it will just copy
the object name. However, in certain cases it will copy more than just the name. Refer to the following table for details.
||If you drag a table at the end of the line, WinSQL will complete the remaining query leaving place-holders for your to type the actual values.
||Drag a table name at the end of the line to complete the SELECT statement.
WinSQL automatically switches the focus from Query
tab to Catalog Detail
tab if the user clicks a node that needs to display
further information. For example, if a user clicks Browse Data
node in the catalog tree, WinSQL will
automatically display the Catalog Detail tab containing the records for the selected table.
IMPORTANT: Integrated view is only available in the Professional Edition of WinSQL.
Older versions of WinSQL only provided Classic View. This type of layout displays the Database catalog in a separate tab. You might
want to use the classic view if you are working with large SQL scripts and need maximum room for your queries.