Why is the column picker disabled when the cursor is in the where clause?
Tony2021
Posts: 8 New member
in SQL Prompt
Why is the column picker disabled when the cursor is in the where clause? This is where I want to pick a column. Also, the columns option in All Suggestions is disabled.
Tagged:
Answers
Unfortunately the column picker doesn't function in WHERE clauses, it only works when it is valid to insert more than one column at a time as mentioned in the note on the documentation page describing it https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/inserting-columns-with-the-column-picker
SELECT statements and afterORDER BY, but not in aWHERE clause.Alex
Have you visited our Help Center?
Not sure why you wouldn't be able to delete your comment, but I can if you want. Hopefully the information I provided above answered your question - I know it does seem limited but the idea is that it is available for places where you can put multiple columns together rather than with WHERE clauses where it is not a list of columns, but of separate search conditions.
Kind regards,
Alex
Have you visited our Help Center?