What are the challenges you face when working across database platforms? Take the survey
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...

Comments

  • Options
    If you are using SQL Prompt 3.0, go to options->candidates and then check last checkbox "Include system objects...".
    That's all :wink:
  • Options
    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
  • Options
    Opps beaten to it :). Thanks shad0fff

    Lionel
    Software Engineer
    Red Gate Software
  • Options
    thanx.
    Missed that one...
Sign In or Register to comment.