![what is sql server management studio what is sql server management studio](https://glennsqlperformance.com/wp-content/uploads/2020/11/image-5.png)
Not visible initially is the Results panel. If it is not visible, don’t worry, it’ll open when there are properties to be displayed. On the right side of the screen is a Properties panel. We’ll create our own database shortly, which will then appear in this drop-down box. This drop-down box is used to select the database you want to work with (as you will recall from Lesson 1, a single DBMS can work with lots of databases). On the left of the toolbar, right above the Object Explorer, is a drop-down box (the first time you open Microsoft SQL Server Management Studio this box will likely contain the word master). Click on the + next to Databases to see the databases that have been already created. You can right-click on objects to see their details, edit them, and perform other tasks too. The left column is the Object Explorer used to browse databases, tables, and more.
![what is sql server management studio what is sql server management studio](https://dotnettutorials.net/wp-content/uploads/2018/07/Connecting-to-SQL-Server-using-SSMS.png)
You’ll be using this button and window extensively. One of those buttons is labeled New Query, and when you click on it you open a window in which you can type and execute SQL. Learn More Buy Navigating SQL Server Management Studioīecause we’ll be spending so much time in Microsoft SQL Server Management Studio, a quick tour of the tool is worthwhile:Īt the top of the screen is a toolbar containing lots of buttons. Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself, 2nd Edition