This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Introduction to SQL Server Management Studio Part two of a two-part series of blogs
Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio. Introduction to SQL Server Management Studio Working with Tabs (this blog) This blog is part of a complete SQL Server tutorial. Don't forget that Wise Owl also run excellent training courses in SQL in the real world!

Introduction to SQL Server Management Studio

Part two of a two-part series of blogs

Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio.

Introduction to SQL Server Management Studio
Working with Tabs (this blog)

This blog is part of a complete SQL Server tutorial. Don't forget that Wise Owl also run excellent training courses in SQL in the real world!

Posted by Andrew Gould on 30 April 2012

Working with Tabs

When you start creating queries you'll need to understand how to work with tabs. Each query window that you create will appear in a new tab at the top of the screen.

This screen contains two query windows, each in its own tab. The asterisk after the name of the leftmost tab indicates that it contains changes that have not been saved.

Creating New Tabs

You can create new query windows quickly by pressing CTRL + N on the keyboard.

You can also click the New Query tool at the top left of the screen.

Switching Between Tabs

The simplest way to switch between tabs is to click on the one you want to view.

You can also click the drop arrow at the top right of the screen and choose a tab from the list that appears.

Closing Lots of Tabs Quickly

If you have lots of query windows open and you want to close (nearly) all of them you can right-click on a tab and choose the option shown below:

Choose the option shown to close all of the open tabs apart from the one on which you right-clicked.

If you want to close all of the open tabs, from the menu choose: Window > Close all Documents.

Creating Tab Groups

You can create horizontal and vertical groups of tabs to help you organise related query windows. The diagram below shows how to do this:

Right-click on a tab and choose either of the two bottom options shown here.

When you have selected one of the options shown above you'll end up with your query windows separated into different tab groups.

You can click and drag on the dividing line between the tab groups to change the height or width of the groups.

Moving Tabs Between Groups

You can move a tab from one group to another by right-clicking on the tab and choosing the option shown in the diagram below:

Choosing the option shown will send the tab into the bottom half of the screen to sit alongside the other tabs in that group.

When you move the final tab out of a tab group that group will be removed.

Parts of this blog
Introduction to SQL Server Management Studio Working with Tabs (this blog)

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Working with Tabs

Creating New Tabs

Switching Between Tabs

Closing Lots of Tabs Quickly

Creating Tab Groups

Moving Tabs Between Groups

Head office

London

Manchester