Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 22 Mar 2007 @ 13:00:58 GMT


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


Subj:   How to get column types in views
 
From:   kaare.wehn

Hi

I'm currently writing a database tool (using .NET C# and ODBC) and I need a method to find the column types of the output of a view. I have tried to use the dbc.Column (and ColumnsX) and it works fine for table columns, but not for views. Columns.ColumnType and Columns.ColumnFormat contains only NULLs.

As a last resort I might send a dummy query like "SELECT * FROM ddd.vvv WHERE 0 = 1" and then read the field definitions from ODBC, but I'd rather not. Performance will suffer.

Using Teradata SQL Assistant I can see the column types by clicking the view on the left hand side of the screen. So, how does SQL Assistant do this?


Thanks!

Kaare Wehn



     
  <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: 27 Dec 2016