Search code examples
sql-serversql-server-data-tools

New column in my table not visible after adding and publishing

I have an existing table => zoo[design] I add to it new column:

zooName nvarchar(50) allow null

Then I updated the server but when i go in zoo[data] and push refresh I can't see the zooName there.

But if I make new Query

select * from zoo

it's display for me the zooName but i can't edit it in the zoo[data]

I closed the project and open it again then it's ok

I don't want to open and close the project every time I need to add new row.

Solution

  • Refresh on your database node from Object Explorer if you are using MSSQL.