I recently started a new job that relies heavily on SQL. I figure the best place to learn if by looking at all the saved views my department already has loaded into our server. I can’t figure out how to view the sql query behind our saved views in SMSS though. Can somebody please walk me through? Yes, I realize I sound like a dumb ass 😂

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.