Data Warehousing Community Forum
February 08, 2012, 10:59:09 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: System tables/views in Teradata  (Read 6499 times)
Allegra
DW Apprentice
**

Reputation: +17/-0
Offline Offline

Posts: 75



View Profile
« 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
Logged
@llegr@
what do you call an Ant with an AK47 ?
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 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
Logged
If most people said what’s on their minds, they’d be speechless.
Allegra
DW Apprentice
**

Reputation: +17/-0
Offline Offline

Posts: 75



View Profile
« Reply #2 on: April 01, 2010, 09:23:35 am »
Thanks a million... Cool
Logged
@llegr@
what do you call an Ant with an AK47 ?
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: