Working with SQL Server 2012 Object Explorer

Use of Object Explorer :-

Object Explorer is a graphical tool for managing SQL Server instances and databases. It is one of several SSMS window panes available from the View menu.Object Explorer provides direct interaction with most SQL Server data objects, such as tables, views, and procedures.

Right-clicking an object, such as a table,will display context-sensitive commands, including query-generators and script generators for object definitions.

SQL Server query writers most commonly use Object Explorer to learn about the structure and definition of the data objects they want to use in their queries.

For example, to learn the names of columns in a table, you follow these steps:

How to open SQL Server 2012 Object Explorer and view the Table Column Names.

1.Connect to the SQL Server, if necessary.

2.Click View from the menu and select Object Explorer.
   Press windows shortcut Key F8 to open SQL Server Object Explorer. 

3.To View the List of Databases,Expand the Databases folder to expose the list of databases.

4.Expand the relevant database to expose the Tables folder.

5.Expand the Tables folder to view the list of tables in the database.

6.Locate the table you are interested in and expand it to find the Columns folder. The Columns folder will display the names, data types, and other information about the columns that make up the table.

 You can even drag the name of a database, table, or column into the query window to have it entered and avoid typing it yourself.