1

For the last few versions of SSMS (SQL Server Management Studio), I have noticed that IntelliSense does not contain the word distinct. Is there a way I can add this to the IntelliSense word bank?

The only instructions for configuring IntelliSense I could find had no options for adding to the word bank.

Is there an undocumented means to do this? While not critical to my productivity, it is something I would like to correct.

  • 1
    SSMS intellisense is fickle at best. There are a couple of 3rd party extensions that can significantly improve this... probably not worth the effort if you're just trying to skip the word distinct though. – Dave Jan 22 '16 at 16:09
  • Probably right. – user66242 Jan 22 '16 at 16:11
2

No, I don't believe there is any way to manipulate the IntelliSense dictionary. And you'll notice other T-SQL keywords are missing from the list, too:

SELECT
DELETE
INSERT
FROM
GROUP
ORDER
JOIN
WHERE
HAVING

UPDATE is there, but only because it is overloaded (a function you can use inside a trigger to see if a specific column was updated).

Further, I'd have to wonder what is wrong with your data model that you're typing DISTINCT enough where auto-complete will have any impact on your productivity at all. DISTINCT really should be rarely used; almost every time I see it in a query, it's being used to remove duplicates caused by bad design or bad join logic.

  • " by bad design or bad join logic" -- While I agree with you in principle, I am forced to work with the data I have, the customers I have, and the queries they are paying me to produce. – user66242 Jan 22 '16 at 18:45
  • 2
    @Rubix_Revenge Understood, but that doesn't make them not bad. – Aaron Bertrand Jan 22 '16 at 18:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy