SQL Server Management Studio Object Explorer


This chapter talks about Object Explorer in SQL Server Management Studio (SSMS) which is an essential part of SQL Server Management Studio (SSMS) since it provides a quick and easy way to connect to databases and manage their objects.

What is Object Explorer and How Do You Open

Object Explorer shows the objects in a hierarchy thereby providing a quick object management solution.  This is the way you will primarily interact with database and server components when using SSMS.

As soon as you start SQL Server Management Studio (SSMS) the Object Explorer should open.  If not then you can open it by one of the following ways:

  1. Pressing the shortcut key F8
  2. From the menus select View > Object Explorer as shown below
Opening Object Explorer

Comments For This Article

get free sql tips
agree to terms