These pages cover SQL Prompt 6. Help for older versions is also available.

Skip to end of metadata
Go to start of metadata
Icon

Tab history is not supported in SQL Server Management Studio 2005 or earlier.

SQL Prompt keeps a history of query tabs you open in SQL Server Management Studio.

Browsing tab history

To browse your tab history, on the SQL Server Management Studio toolbar, click Tab History:

The tab history window is displayed:

The tab history window shows the following information about each tab:

  • the file name
  • the SQL code
  • the SQL Server and database the tab was connected to
  • the time the tab was closed

To view a list of tabs that are currently open, click Open tabs:

Using the keyboard

Icon

To browse open tabs, press Ctrl + Q.

You can also navigate the tab history window using the keyboard: 

  • To move through the tab list, press the Up or Down arrows.
  • To open the selected tab, press Enter.
  • To switch between the All tabs and Open tabs lists, press Ctrl + Left arrow or Ctrl + Right arrow.

Renaming a closed tab

  1. In the tab list, right-click the tab you want to rename, and click Rename:
  2. Type a new name for the tab, and press Enter.
Icon

You can't rename open tabs.

Closing an open tab

In the tab list, right-click the tab you want to close, and click Close:

 

Removing tabs from the history

Icon

When you remove a tab from the history it is permanently deleted; you can't restore it.

You can remove a single closed tab, or a set of old closed tabs from the history.

To remove a single tab, in the tab list, right-click the tab you want to remove and click Remove:


 

To remove old tabs, in the tab list, right-click the oldest tab you want to keep and click Remove tabs older than this:

Restoring open tabs

When you start SQL Server Management Studio, SQL Prompt automatically restores open tabs from your previous session.

If you don't want SQL Prompt to restore tabs:

  1. On the SQL Prompt menu, click Options.
  2. Under Tabs, click Tab history:
  3. Under Restore tabs, clear the Restore open tabs when SQL Server Management Studio starts check box.
  • No labels