title: View created in SQL Server Management Studio but not visible in "Views" section
body: <p>I created a view in SQL Server Management Studio 18 and I am getting the following message:
  &quot;Commands completed successfully.&quot; which I guess means that the view has been created. However I cannot see the view in the views section of the database in the Object Explorer.</p>
  <p>I confirmed that the view has been created by running the query again and i got an error that the object already exists.</p>
  <p>This is the code I used to create the view:</p>
  <pre><code>    GO 
      CREATE VIEW VIEW_1 as SELECT dea.continent, dea.location, dea.date, dea.population, vac.new_vaccinations, SUM(cast(vac.new_vaccinations as INT)) OVER (PARTITION BY dea.location ORDER BY dea.location,dea.date) AS rolling_new_vax 
      FROM [Portfolio Project _1]..['covid vaccinations$'] vac JOIN [Portfolio Project _1]..['covid deaths$'] dea 
      ON vac.location =dea.location AND vac.date = dea.date 
      WHERE dea.continent IS NOT NULL AND dea.location = 'Canada'
  </code></pre>