CODEWITHSUNDEEP
sqlsql-server-2008
user2720620
user2720620

Reputation: 153

Newly added column is not visible inside insert query

Added a new column to the existing table. Column is also visible after firing select query.

But while inserting record into that table. The new added column is not visible in 

INSERT INTO template(ID,name,validity,status) 
VALUES (1,'sudhakar','2014-04-05',available)

In the above query Status is the newly added column which is not visible inside the insert query

Upvotes: 2

Views: 1619

Answers (1)

deterministicFail
deterministicFail

Reputation: 1285

If you change the structure of an object, you have to refresh IntelliSense

Edit -> IntelliSense -> Refresh local Cache

or

ctrl + shift + R

Upvotes: 8

Related Questions