Menu
I am using SQL server 2008. If I am working on the Management Studio's query analyser, and I go ahead and create a new table or view, then the SSMS does not see the newly created object for intellisense.
What do I do to make SSMS see and autosuggest from the newly created tables/views too?
749
In SSMS, in Object Explorer, connect to the instance of Database Engine that contains the database to be modified. In Object Explorer, expand the Databases node and then expand the database that will contain the new table. In Object Explorer, right-click the Tables node of your database and then click New Table.
To show table properties in the Properties window. In Object Explorer, select the table for which you want to show properties. Right-click the table and choose Properties from the shortcut menu. For more information, see Table Properties - SSMS.
For those using SQL Server Management Studio 2016 you simply need to hit 'F5' or go to 'View > Refresh' and your recently added tables should appear.
In SQL, to fetch data from multiple tables, the join operator is used. The join operator adds or removes rows in the virtual table that is used by SQL server to process data before the other steps of the query consume the data.
Have you tried to refresh the intellisense cache
Edit -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)
66
Go to the menus:
Edit > Intellisense > Refresh local cache or press the shortcut key: Ctrl-Shift-R
25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
