In SQL Server 2005 or previous version , whenever I was working to write the script, query or stored procedures at that time if i forgot object names which was going to used in the script, then i was need to get the proper object name by system query or from the list of objects in management studio.

But SQL Server 2008 introduce a new feature for the above such problem. Yes that is "Intellisense" feature. Using it we can easily get all the objects list in query analyzer. I am going to put very very small demo of this feature here.

Creating objects.

CREATE DATABASE IntellisenseDB

GO

USE IntellisenseDB

GO

IF ( Object_id('IntellisenseTable') > 0 )
  DROP TABLE IntellisenseTable

GO

CREATE TABLE IntellisenseTable
  (
     Id    INT,
     Value VARCHAR(10)
  )

GO 

Let's look at the below images, how Intellisense works. From below screen shot , I am selecting the database created above.















This image list all the objects of  inside of selected database as above.







I hope you liked this new feature and post as well. Happy Development!!!