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.

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