SQL Server 2008 finally provides intellisense in the query editor of SQL Management Studio. For a long period of time this was a top request from the developer community to the SQL/Data division of MS. Now they have finally done it (though it’s not yet as advanced as Visual Studio).
So as of now we’ll get intellisense for tables, views. Note that in the figure both tables and views are shown – as well as schemas. In this case objects starting with v denote view. Once you put a dot after the database all the schemas present under that are shown.
If you use alias it understands it and all the column names for the alias (table) are shown.
Now as I mentioned the intellisense feature in SQL Server 2008 is not as advanced and complete as Visual Studio. So it primarily works for SELECT statements.
Here’s the official list – http://msdn2.microsoft.com/en-us/library/bb934481(SQL.100).aspx
(Though the official MSDN list says it supports Stored Proc, I tried it on Katmai RC and Beta releases and it did not work, may be MS has fixed it in RTM bits).