Autocomplete in Intellisense SSMS 2017. Where'd it go?
Having just spent two days with the same problem, I finally found the answer (in my case).  Intellisense does not work in SQLCMD mode, and mine was on by default (Tools, Options, Query Execution, SQL Server, General, second last!)