Options

No intellisense for INFORMATION_SCHEMA views

MladenPrajdicMladenPrajdic Posts: 10 Bronze 2
edited January 29, 2007 1:02PM in SQL Prompt Previous Versions
the subject says it all :))

it's really annoying...
· Share on Twitter

Comments

  • Options
    shad0fffshad0fff Posts: 1
    If you are using SQL Prompt 3.0, go to options->candidates and then check last checkbox "Include system objects...".
    That's all :wink:
    · Share on Twitter
  • Options
    LionelLionel Posts: 157
    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
    Software Engineer
    Red Gate Software
    · Share on Twitter
  • Options
    LionelLionel Posts: 157
    Opps beaten to it :). Thanks shad0fff

    Lionel
    Software Engineer
    Red Gate Software
    · Share on Twitter
  • Options
    MladenPrajdicMladenPrajdic Posts: 10 Bronze 2
    thanx.
    Missed that one...
    · Share on Twitter
Sign In or Register to comment.