Let try to understand different area of SQL server Management Studio window. as shown below screenshot the numbering and each numbers are explained in the below.
- This is the main Manu of the SSMS where you can see many options
- This is important window which shows the current database which you are using, creating Table and performing queries.
- Click to get new window for Query/Command space.
- Click to execute the query. If you will click on execute it will run all written queries in the query window. If you want to run specific query you can select that specific line or portion of query and then click on Execute button to run it.
- this is the window/space where you can write your queries and SQL commands.
- This is the navigation for all database and Tables which you have created within the Database. Sometimes you need to refresh table from navigation bar, if data is not reflecting after query run. (select table > right click > click on refresh table button)
- this is the Messages area where it will show your successful or error command messages.
These are the very basic options in Management studio, which you will use mostly during your day to day SQL command,