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.
Who is Participating?
dsackerContract ERP Admin/ConsultantCommented:
Right-click on the Views, and select "Refresh".
Vitor MontalvãoMSSQL Senior EngineerCommented:
No screenshot.
David L. HansenProgrammer AnalystCommented:
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).
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Brian CroweDatabase AdministratorCommented:
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
Lee SavidgeCommented:
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.
isamesAuthor Commented:
That worked.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.