No intellisense for INFORMATION_SCHEMA views

MladenPrajdic

the subject says it all )

it's really annoying...

shad0fff

If you are using SQL Prompt 3.0, go to options->candidates and then check last checkbox "Include system objects...".
That's all

Lionel

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.

Lionel

Lionel

Opps beaten to it . Thanks shad0fff

Lionel

MladenPrajdic

thanx.
Missed that one...