How do I view a query in a SQL view?
To view the SQL, go to the Home tab. Select SQL View from the View menu and you will see the SQL of your query. How do I see the query of a view in SQL Server? In Object Explorer, expand the database that contains the view to which you want to view the properties, and then expand the Views …