Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 Mar 2007 @ 15:45:48 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: How to get column types in views
From:   Dempsey, Mike

You say you are using ODBC so just use the ODBC API function provided.

SQLColumns() returns not only the column names but also the data types and 'Nullable' (etc.) attributes. This works for both tables and views.

If you are not using the API directly, but ADO.Net (or something) I can not give you the actual details. If I understand it correctly however the catalog data was made available in either .Net 1.1 or 2.0.

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020