Menu
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.
Click Query > Connection > Connect to connect to the server that contains the database you want to access. Select the appropriate StarTeam Server database. Open the tuning script, by choosing File > Open > foldername\scriptname. Execute the script, by clicking the Execute button on the toolbar or by pressing F5.
Using the OBJECT_ID and the IF ELSE statement to check whether a table exists or not. Alternative 2 : Using the INFORMATION_SCHEMA. TABLES and SQL EXISTS Operator to check whether a table exists or not.
Press Ctrl-Shift-R to refresh the intellisense.
If you prefer, you can use the menu to refresh the cache:
Edit>Intellisense>Refresh Local Cache
The good thing using the menu, is that you will learn some new Intellisense hot-keys...
SQL Server Management Studio Intellisense doesn’t work after schema changes
You probably did what I always do. I often create a table while connected to the wrong database, or the default database. For me, the default database is 'master' so I have a lot of garbage in my master DB :)
Randy
I right-click on the Tables and Select Refresh from the context-sensitive menu (Ctrl-R works too)
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