Enable IntelliSense and Refresh IntelliSense Local Cache in SSMS

In SQL Server Management Studio 2008 and later versions, you can use IntelliSense feature that will auto complete object names and properties while you are writing queries. IntelliSense is ON by default, but if it does not work, here are the steps how to fix it:

You need to be connected to SQL Server 2008 or later versions, because IntelliSense does not work with previous versions of SQL Server:

check sql server version

To check if IntelliSense is enabled:
In SQL Server Management Studio:
Go to Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense

intellisense options in ssms

Make sure the 'Enable IntelliSense' is checked.

You can also check if IntelliSense is enabled from Query menu:

check that IntelliSense is enabled from query menu

To check 'Statement completion' options:
From Tools -> Options -> Text Editor -> Transact-SQL -> General


Make sure that 'Auto list members' and 'Parameter information' are checked

If you are not able to see the latest schema changes in the database, refresh IntelliSense Local Cache:

Go to Edit -> IntelliSense -> Refresh Local Cache:

refresh intellisense local cache

Or press CTRL+SHIFT+R to Refresh Local IntelliSense Cache