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

SQL Prompt Column Picker greyed

Hello,

I have a SQL Prompt License and I use the Management Studio SQL Server 18.
My problem is that the columns which are in one table, they doesn´t appears. 

For example:
SELECT *
FROM dbo.Example 

I expect that all columns, which are in dbo.Example will appear.
Instead nothing appears. The column picker is also greyed. I can only choose "All Suggestions" and there are my snippets ore other suggestions.

What can I do to fix the problem?

Thank you!

Sorry about my english! :)

Best regards,
Selli



Selli
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    Hi Selli,

    Can you confirm the full version of your SQL Prompt?

    You may need to refresh the suggestions from time to time. Please go to SQL Prompt->Refresh suggestions. Then please try again.

    The column picker is enabled once the table is selected. 
    Tianjiao_Li
    0
  • whodis
    I'm having the same problem. Tables Views Columns and Stored Procedures are greyed out. I have a license, I've enabled "List all database columns after a Select statement", I've refreshed suggestions, I've restarted machine... No prompts... Im on 10.15.1.12422
    whodis
    0

Add comment

Please sign in to leave a comment.