SQL Server smart sensing does not work

Sometimes it is found that the intelligent perception of SQL server does not work. You can try the following solution:

 

1. Make sure that intelligent sensing is enabled correctly.

 

 

Enable: (auto LIST members)

 

2. You cannot intelligently prompt some newly created objects. You can solve this problem by refreshing the local cache:

 

 

For more information, see troubleshooting intelliisense (SQL Server Management studio)

Http://msdn.microsoft.com/zh-cn/library/ms173434.aspx