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.
CREATE DATABASE IntellisenseDB
IF ( Object_id('IntellisenseTable') > 0 )
DROP TABLE IntellisenseTable
CREATE TABLE IntellisenseTable
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.