Code Completion of SQL Statements in 2005

Will the new tools for SQL 2005 give us code completion of SQL Statements, e.g. if I type the following sql

USE pubs
GO

SELECT pub.
FROM publishers AS pub

When I type the "pub." will I see a list of the available columns in the publishers table. This type of feature has been available in TOAD for years and years, will SQL Server programmer finally get this in the 2005 release.

Cheers,

Colin

Hi Colin -
I am sad to say that you will not see this feature in SQL Server 2005. We will try our best to add it in the future releases.

Regards,
Michael|||Thanks for the reply, I've added a suggestion to MSDN Feedback

http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=d02919ba-6429-4532-9bb7-4bc63e80c9b9

Hopefully we will get this feature "eventually" although if we have to wait for the version of SQL Server AFTER 2005 then I think we are in for a long wait.

|||One of my coleagues who went to the code-off at PDC said that someone there demo'd intellisense for SQL. I'm sad I missed that session...|||I suspect this was one of the LINQ sessions, in this case the intellisense is inside of the VS Editor as long as you are using System.Query which will be in the next version of VS after VS2005.|||Here is the like to the product, and at $25 is pretty reasonable:
http://www.promptsql.com/index.html|||This may have been the video they saw at the PDC:
http://channel9.msdn.com/Showpost.aspx?postid=121794
Regard,
Damian