Data Warehousing Community Forum

Databases => Teradata => Topic started by: Allegra on March 29, 2010, 02:40:16 pm

Title: System tables/views in Teradata
Post by: Allegra on March 29, 2010, 02:40:16 pm

What are the system tables/views in Teradata ??

In Oracle RDBMS, below are the set of system tables/views..

ALL_TABLES
ALL_TAB_COLUMNS
ALL_PROCEDURES
ALL_ERRORS
ALL_SOURCE

What are the equivalent tables/views in Teradata

Title: Re: System tables/views in Teradata
Post by: Whoever on March 31, 2010, 08:26:31 pm

Quote from: Allegra on March 29, 2010, 02:40:16 pm

What are the equivalent tables/views in Teradata

ALL_TABLES - DBC.Tables
ALL_TAB_COLUMNS - DBC.Columns
ALL_PROCEDURES - DBC.TVM, DBC.TVFields
ALL_ERRORS - DBC.ErrorMsgs
ALL_SOURCE - DBC.TVM, DBC.TVFields

Beyond this official help doc might be able to help - http://www.info.teradata.com/eDownload.cfm?itemid=033360003

Title: Re: System tables/views in Teradata
Post by: Allegra on April 01, 2010, 09:23:35 am

Thanks a million... 8)