title: Why can't I SELECT * FROM the view I just created?
body: <p>I created a view </p>
  
  <pre><code>CREATE VIEW BenefitsView AS SELECT * FROM Benefits
  </code></pre>
  
  <p>I get a message saying this ran successfully.
  Then I try to select everything from that view</p>
  
  <pre><code>SELECT * FROM BenefitsView 
  </code></pre>
  
  <p>but I'm getting a an error:</p>
  
  <blockquote>
    <p>saying <code>BenefitsView</code> is an invalid object name?</p>
  </blockquote>
  
  <p>Why? Also I've tried to find the view in the object explorer but can't?</p>