Why is the column picker disabled when the cursor is in the where clause?

Tony2021

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.

Alex B

Hi @Tony2021,

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

The Column Picker is only available when it is valid syntax to insert more than one column into your code at this point in the query, and there are columns available to insert. For example, the column picker is available for SELECT statements and after ORDER BY, but not in a WHERE clause.

Kind regards,
Alex

Tony2021

(why can't I delete a comment?)

Alex B

Hi @Tony2021,

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