title: How to create a stored procedure sql server to see all tables in a databse?
body: <p>So far in the website I have only found stored procedures to list all the tables in a database, but what I really want to know is how to create a stored procedure in SQL Server to display all data of all tables in a specific database.</p>
  
  <p>I don't want to join the tables and then display a huge table, I want to create some kind of loop that takes the first table of the database, performs a </p>
  
  <pre><code>SELECT * FROM &lt;Table&gt;
  </code></pre>
  
  <p>query, and then continues with the next table of the database and so on until all tables are displayed.</p>
  
  <p>I know it should be easy but I have never created a stored procedure before so I don't know how to use the variables or go through the tables.</p>
  
  <p>Thank you</p>