isames
asked on
SQL Views
I have created a view. I queried the view and got the result expected. However when I go to the database, and look under Views, I don't see the view there.
I attached a screenshot.
I attached a screenshot.
No screenshot.
Make sure you are on the server you expect and the database you expect (I wonder if you are just looking under the wrong database).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
My guess is that you created it on the master database or somewhere else accidentally. I of course have never done this myself but I've heard of other people doing it :-P
If you don't get the view in Intellisense, then I think you can force a refresh of the meta data by pressing Ctrl+Shift+R
Right mouse click on the database and do refresh to refresh the tree.
Right mouse click on the database and do refresh to refresh the tree.
ASKER
That worked.
Thanks!!!
Thanks!!!