Link to home
Start Free TrialLog in
Avatar of isames
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.
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

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
Avatar of dsacker
dsacker
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of isames
isames

ASKER

That worked.

Thanks!!!