Most of the time you interact with a database by writing and executing SQL queries. In this way, SQL document is an essential part of every database tool in dbForge product line. It is a place where you create SQL statements in order to run them against a database server. This topic gives you an overview of SQL document layout, views, and functions.
On the Standard toolbar, click New SQL.
Alternatively, double-click near the tab of the other opened SQL Document, and the new document will appear. Please note, that this way of creating a new document will work only provided that you have other documents opened.
The following image is an example of the SQL document.
Actual document look may slightly vary from the image above, depending on the product you use.
Each SQL document includes different representations of the content. They are called document views. On the above screen-shot you can see two document views: Text and Data.
To switch to a specific view:
The query execution results can be represented in two ways - in text and in grid formats.
To represent results as text, on the SQL toolbar, click the Results as Text button before query execution. The following image represents a sample of query execution results in text format.
To represent results as grid, on the SQL toolbar, click the Results as Grid button before query execution. The following image represents a sample of query execution results in grid format.
SQL document has two types of view layout: Split Layout and Combined Layout. To switch document layout use appropriate buttons at the bottom-right corner of the document.
In the split layout a document has one prominent (main) view which is aligned to the top of the document view port. Other views are called additional, they are displayed in the bottom area of the document view port.
Main view remains always in split layout visible and you can toggle only additional views. But you can see two views at a time to avoid unnecessary switching.
To temporary hide additional document views, click the Hide/Show additional document views button at the bottom-right corner of the document, or just press CTRL+R.
To change the main document view, use the Swap main and additional documents views button to swap the main view and active additional view.
In the combined layout you can see only one view at a time. A document view fills entire document view port. Typically, you need this layout when you a focusing on one specific document representation (for example, when you extensively work with data).