Tangara G

Tangara G

  • NA
  • 298
  • 93.5k

How to save the query in Views in the same database name?

Sep 20 2016 11:06 PM
Hi experts,
 
 
I have created a query using Views in Ms SQL 2012 and saved it.
However, I am not able to see this query I have written in the database where it will list all the tables created.  Neither can I find it in the Views folder.
And it seems every time I wanted to view this query or modify it, I have to re-created all over again.
 
The weird thing is that it will stay at the Server Explorer in Visual Studio.
 
Hope someone can advise me how to make it store permanently in Ms SQL 2012 Management Studio so that I can retrieve it.
 
Tks.
 

Answers (2)