How can we help you today? How can we help you today?

DMV columns appearing in Prompts

Often while typing, I am prompted with columns from various Dynamic Management Views.

For example, when I type:
IF ISNULL(OBJECT_ID

I am prompted with the object_id column from sys.dm_qn_subscriptions.

How do I disable this?
Dave Pendleton
0

Comments

2 comments

Sort by
  • Anu D
    Thanks for your post.

    From your problem specification if I am not getting you wrong I feel following settings should help:

    SQL Prompt 4 --> Options --> Suggestions --> Type of suggestion --> deselect option List system objects

    If this doesn't resolve can you kindly let us know the steps to reproduce the problem?
    Anu D
    0
  • Dave Pendleton
    I want system objects to be suggested, just not the columns.

    Has this behavior changed in this version?
    Dave Pendleton
    0

Add comment

Please sign in to leave a comment.