Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 Apr 2011 @ 08:31:09 GMT


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


Subj:   How to find list of database objects in teradata.
 
From:   Gogate, Mandar

Hello All,

I need to understand, how do we find the list of database objects, say Tables and Indexes in teradata as we have all_objects, user_objects and dba_objects in Oracle.

One way I got is, if teradata user is having an access to dbc.tables, dbc.indexes or dbc.TVM then we can find that out. But what in case new user is not having an access to these base tables? In Oracle using all_tables or user_tables we can easily identify that. Is there any such way available in teradata too?


Thanks in advance,

Mandar



     
  <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