title: Show column name and data type in Teradata?
body: <p>Is there a way to get <em>column name</em> and <em>data type</em> in a <code>Teradata SQL Assistant 15.0</code>view?</p>
  
  <p>In <code>Oracle 11g</code> you can do something like <code>desc tablename</code>  and get a script result set of the following :</p>
  
  <blockquote>
    <p>Name                           Null     Type                                                                                                                                                                                          </p>
    
    <hr>
    
    <p>test_id                                 NOT NULL NUMBER(19)<br>
    test_name                               VARCHAR2(255)<br>
    test_department                         VARCHAR2(255)<br>
    test_year                               TIMESTAMP(6)<br>
    test_external_id                        NUMBER(10)</p>
  </blockquote>
  
  <p><br></p>
  
  <p>So far I've tried <code>help view viewname</code> and the result provides all <em>column names</em> but the values for the <em>data type</em> are all nulls.</p>