title: List all columns with datatype from a specific table in Snowflake
body: <p>I tried the answers in this very similar question: <a href="https://stackoverflow.com/questions/61917196/list-all-columns-wtih-datatype-in-specific-table-in-snowflake/61995811#61995811">List all columns wtih datatype in specific table in Snowflake</a> and they work in the Snowflake WebUI but not in Teradata SQL Assistant.</p>
  <p>But even using SHOW COLUMNS IN TABLE MYSCHEMA.MYTABLE; doesn't give me exactly what I need. I want the query to return information like this:</p>
  <pre><code>Columns     Data Type
  REGION_ID   NUMBER(38,0)
  STORE_NAME  VARCHAR(20)
  VALID_NAME  VARCHAR(1)
  </code></pre>
  <p>The data_type column from SHOW COLUMNS IN TABLE MYSCHEMA.MYTABLE; doesn't look like the above grid which is from the Snowflake WebUI (&quot;View Details&quot; command by right clicking the table name in left hand side of the &quot;Find database objects&quot; section).</p>
  <p>The view from SHOW COLUMNS... looks like this:</p>
  <pre><code>data_type
  {&quot;type&quot;:&quot;FIXED&quot;,&quot;precision&quot;:38,&quot;scale&quot;:0,&quot;nullable&quot;:true}
  {&quot;type&quot;:&quot;TEXT&quot;,&quot;length&quot;:20,&quot;byteLength&quot;:80,&quot;nullable&quot;:true,&quot;fixed&quot;:false}
  {&quot;type&quot;:&quot;TEXT&quot;,&quot;length&quot;:1,&quot;byteLength&quot;:4,&quot;nullable&quot;:true,&quot;fixed&quot;:false}
  </code></pre>
  <p>Yes, similar but I'm looking for something equivalent to the grid above or the Teradata SHOW TABLE command.</p>