title: sql query to find datatypes in teradata
body: <p>I've never dealt with Teradata database before, I need to find out the data types for a table in Teradata I tried the below queries but none of them worked</p>
  
  <pre><code>describe table tablename; show create table tablename;help table tablename;
  </code></pre>
  
  <p>When I did show table I realized that it is a view and I tried 
  <code>show view view name; 
  help view view name;</code></p>
  
  <p>none of the above queries gave me the datatypes for the view I'm looking to find out. i googled around and tried my findings none of them worked.</p>
  
  <p>Please help me with the query to find out the data types in teradata.</p>
  
  <p>Thanks in advance</p>