title: How to get a view table query (code) in SQL Server 2008 Management Studio
body: <p>I have a view in SQL Server 2008 and would like to view it in Management Studio.</p>
  
  <p>Example:</p>
  
  <pre><code>--is the underlying query for the view Example_1
  select * 
  from table_aView 
  </code></pre>
  
  <p>View name: <code>Example_1</code></p>
  
  <p>How to get the query of the corresponding view table (query used to create the view)?</p>
  
  <p>Thanks in advance</p>