Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 Jul 2009 @ 20:23:00 GMT


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


Subj:   Query to display all possible object kinds?
 
From:   G, Hemanth Kumar

Hello,

Is there any query that would display all the possible object kinds in Teradata? For e.g, consider this query. This displays only objects present in my database.

     SELECT DISTINCT TableKind FROM DBC.Tables;

     TableKind
     ---------
     H
     F
     M
     V
     T
     U

I am interested in getting to know all other possible object kinds supported in Teradata (other than those present in my database).

Is there any query that would give my answer?


Thanks in advance,

Hemanth.



     
  <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: 15 Jun 2023