Reset SQL Server Management Studios intellisense after a schema change
For some reason it's taken me a while to cotton on to doing this. In fact I currently have intellisense in management studio switched off as it's main hobbies seem to be trolling me typing.?
My main annoyance is the sea of red every time you add a table or column and the lack of red if you delete a column.?
Anyway, I worked out over the weekend that you can reset the intellisense with ctrl+shit+r
In case you weren't sure how to toggle the intellisense on and off, see the picture. It's under Tools -> Options -> Text Editor -> Transact-SQL -> Intellisense.