Overview
This chapter talks about Object Explorer in SQL Server Management Studio (SSMS), an essential part of SSMS, as it provides a quick and easy way to connect to databases and manage their objects.
Explanation
Object Explorer shows the objects in a hierarchy, thereby providing a quick object management solution. This is the way you will primarily interact with the database and server components when using SSMS.
As soon as you start SSMS, the Object Explorer should open. If not, then you can open it in one of the following ways:
- Pressing the shortcut key F8.
- From the menus, select View > Object Explorer, as shown below.
Haroon Ashraf’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional.
He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award.
His programming career began in 2006 working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data.
His work and interest revolves around Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration.
He has recently earned “Knowledge Management and Big Data in Business” certificate from The Polytechnic University of Hong Kong.
- MSSQLTips Awards: Trendsetter (25+ tips) – 2020 | Author of the Year Contender – 2018-2020
