How to manipulate documents

The topic describes how to manipulate documents in dbForge Studio.

Manage documents

The Windows Dialog Box allows you to switch between documents and manage them. To open it, select Windows from the Window menu. This dialog allows you to save and close multiple documents at once, and activate a required document.

To save document(s) select required document(s) and click the Save button.

To close document(s) select required document(s) and click the Close Window(s) button.

Note

To close an opened document, click the document title with middle mouse button (mouse wheel).

To activate a required document, select the document and click Activate.

Each SQL document includes different representations of the content—document views.

The current and other available views are shown on the bottom pane of the document. To add a view to the pane, click Open document view (the plus icon) and select the required view from the list.

You can change a view as follows:

  • To switch to a specific view, click the view name.
  • To cycle through available views, press the F7 key.

Note

You can change the shortcut for cycling through available document views.

  1. Go to Tools > Options > Environment > Keyboard.

  2. In the Show commands containing field, enter Window.NextDocView.

  3. Click inside the Press shortcut keys field, press the desired keys on your keyboard, and click Assign.

Work with document tab groups

Multiple documents can be organized into horizontal or vertical tab groups for organizing a workspace for working with several documents at the same time. New document tab group can be created either by dragging document to the required place or by selecting New Horizontal Tab Group or New Vertical Tab Group from the document header shortcut menu.

Documents can be moved between tab groups by dragging-n-dropping or by selecting a required command from the shortcut menu.

Restore tabs

Starting from dbForge Studio for SQL Server v3.8, the restoring of open tabs has been enabled. If you accidentally close the application or it stops responding and closes, document tabs will be saved to cash and restored when you open dbForge Studio again.

To customize the restore options, go to Tools > Options > Environment > Documents > Restore and adjust the settings:

  • General—The time interval at which the restore information is saved automatically.
  • Restorable File Types—The types of files to be saved and restored.

Document header shortcut menu

The document header shortcut menu includes the following options:

  • Save <Name>.sql—Saves a current SQL document.
  • Close—Closes a current document.
  • Close All But This—Closes all documents excepting the selected one.
  • Copy Full Path—Copies the full path for the document.
  • Open Containing Folder—Opens the folder containing the document.
  • Float—Detaches the window.
  • New Horizontal Tab Group—Creates new horizontal tab group.
  • New Vertical Tab Group—Creates new vertical tab group.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?