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.
LVL 1
isamesAsked:
Who is Participating?
 
dsackerContract ERP Admin/ConsultantCommented:
Right-click on the Views, and select "Refresh".
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
No screenshot.
0
 
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).
0
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
0
 
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.
0
 
isamesAuthor Commented:
That worked.

Thanks!!!
0
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.