I recently started a new job that relies heavily on SQL. I can’t figure out how to view the SQL query behind our saved views in SMSS. Can somebody please walk me through?
Thank you in advance
When I right click on the saved view there a ton of options but nothing by sticks out. My best guess was edit top 200 rows would show me the query but it won’t. I don’t have write access, only read access.
New contributor
Bigcat1148 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
4