title: Listing tables and their structure
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/549799/printing-tables-structure-schema">Printing Table&#39;s structure/schema</a><br>
    <a href="https://stackoverflow.com/questions/7177586/oracle-has-describe-to-get-all-the-details-of-the-table-like-wise-does-t-sql-h">oracle has &#39;DESCRIBE&#39; to get all the details of the table like wise does t/sql has any thing</a>  </p>
  </blockquote>
  
  
  
  <p>I want to get list of my tables with their structure.
  Suppose I have 20 or more than .
  How can I do it?
  This query get me list of tables: </p>
  
  <pre><code> SELECT * FROM INFORMATION_SCHEMA.Tables
  </code></pre>
  
  <p>but 
  I want  this</p>
  
  <pre><code>   Name    Structure
  
  
     Product        ID int Primary key,Name nvarchar(50),...........
     Group          ID int Primary key, Name nvarchar(50),..........
     Employee       ID int Primary Key,Name nvarchar(50), Address (300), ........
  </code></pre>