Whenever we create a new object (table/View/Stored procedure etc) in SQL server , the change will not be immediately reflected in query window.
Intelisense works for the existing artifacts , but the new ones will be effective when we restart the SSMS instance.
For example, assume you are creating a new table.
CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
...
Continue Reading AnithaEswaran’s Article on their blog
Refresh new objects in SQL server
Whenever we create a new object (table/View/Stored procedure etc) in SQL server , the change will not be immediately reflected in query window. Intelisense works for the existing artifacts , but the new ones will be effective when we restart the SSMS instance. For example, assume you are creating a new table.
Blog Syndicated with AnithaEswaran’s Permission
More About This Author
Array
- Finance & Operations15 April 2024New pricing for Microsoft Dynamics 365 effective October 2024
- Finance & Operations7 April 2024Virtual entity in Data Management – 10.0.39
- Finance & Operations5 April 2024One Dynamics One Platform – D365FO – LCS – PowerPlatform
- Finance & Operations24 March 2024D365FO Service updates