Split Query Window in SQL Server Management Studio(SSMS)

Introduction

Sometime we may write a long query in our query window and we may need to refer the objects or other part of the T-SQL frequently. For that we may be scrolling up and down in the query window. But we have an awesome option for that in the SQL Query Window, which many of us may not be aware of.

Split Query Window in SSMS

To split the Query window, Click the splitter bar located just above the scroll bar.

Fig 1. Splitter bar just above the Scroll Bar (Highlighted with Red)

When we drag the splitter bar downwards, the query window will be splitted into two. So we do not need to scroll each time to view the upper side contents.

Fig 2. Splitted Query Window

To get back to single pane view, just double click the splitter bar dividing the two pane.

Fig. 3 Splitter Bar – Once double clicked, single pane view (as like Fig. 1)

Conclusion

We can split the query window by dragging down the Splitter Bar. I hope this tip will be more useful. Please share your feedback in the comment section and share this article in your social medias.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

WordPress.com.

Up ↑

%d bloggers like this: