title: Get table schema in Redshift
body: <p>Hello I am trying to retrieve the schema of an existing table. I am mysql developer and am trying to work with amazon redshift. How can I export the schema of an existing table. In mysql we can use the show create table command.</p>
  
  <pre><code>SHOW CREATE TABLE tblName;
  </code></pre>