Enable Intellisense in SQL Server

Turn on auto-complete and syntax help to write SQL queries faster.

IntelliSense is the auto-complete and syntax-checking feature inside SQL Server Management Studio (SSMS) that suggests table names, column names, and keywords as you type. When it's switched off or out of date, writing queries becomes noticeably slower.

Step 1: Turn IntelliSense On

Go to Tools → Options → Text Editor → Transact-SQL → IntelliSense, and make sure "Enable IntelliSense" is checked.

Step 2: Use the Keyboard Shortcut

You can toggle IntelliSense at any time with Ctrl + Shift + Q, without digging through the menu.

Step 3: Refresh the Local Cache

If you've just created a new table or column and it isn't showing up in suggestions, refresh the cache manually:

Edit menu → IntelliSense → Refresh Local Cache
(Shortcut: Ctrl + Shift + R)
💡 Tip: IntelliSense only works against databases in compatibility level 90 or higher — very old databases may need their compatibility level updated first.

Troubleshooting Checklist

  • Confirm you're connected to the correct database context (top-left dropdown in the query window)
  • Check that "Enable IntelliSense" is ticked in Tools → Options
  • Restart SSMS if suggestions still don't appear after a cache refresh
  • Verify the SSMS version — very old builds have limited IntelliSense support

With IntelliSense working properly, you'll write queries faster and catch typos in table or column names before you even run the script.

Ready to go beyond the basics?

Get hands-on training, live mentorship, and placement support with Uncodemy's Data Analytics Course.

Explore Data Analytics Course →