IntelliSense not working in your management studio? Here are a few settings to check.
1)Make sure that IntelliSense is enabled for Management Studio under:
Tools > Options > Text Editor > Transact-SQL > IntelliSense
2)Make sure that IntelliSense is enabled for the current query window by checking:
Query > IntelliSense Enabled menu option (it should be enabled)
3)IntelliSense does not work in SQLCMD mode, ensure that you haven’t enabled this by checking:
Query > SQLCMD Mode menu option (it should NOT be enabled):
4)Check that your script isn’t too large. To prevent performance issues, SSMS will not try to parse a script that is larger than the size set in:
Tools > Options > Text Editor > Transact-SQL > IntelliSense > Maximum script size.
You can adjust this setting if you are working with very large files, or consider breaking them up into smaller scripts