SQL Prompt will give you intelisense on [INFORMATION_SCHEMA]. You need to enable it in the options menu as it is disabled by default (We had endless debates if it should be on by default). To enable it go to Candidates tab in the options dialog and check the box which says "Include system objects in the candidate list". It will be in the Other objects group. Hope that helps.
Comments
That's all
Lionel
Red Gate Software
Lionel
Red Gate Software
Missed that one...