Archives of the TeradataForum

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

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

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>>