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

• 
  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

  Alex B August 26, 2021 16:53

  - 0 +
• 
  (why can't I delete a comment?)

  Tony2021 August 26, 2021 18:36

  - 0 +
• 
  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

  Alex B September 02, 2021 16:54

  - 0 +

Add comment

Please sign in to leave a comment.