Archives of the TeradataForum
Message Posted: Tue, 12 Apr 2011 @ 08:31:09 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|