Data Warehousing Community Forum Data Warehousing Community Forum
The Warehouse of Data warehousing knowledge ...
 
Home Help Search Login Register
*
Welcome, Guest. Please login or register.
Did you miss your activation email? 		September 06, 2010, 02:13:46 am


Login with username, password and session length


Data Warehousing Community Forum > Databases > Teradata > Topic: System tables/views in Teradata
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: System tables/views in Teradata  (Read 579 times)
Allegra
DW Apprentice
**

Reputation: +14/-0
Offline Offline

Posts: 52



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


Forum Don


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
You don't get it.  I built this place. Down here, I make the rules. Down here, I make the threats. Down here, I'm God.
Allegra
DW Apprentice
**

Reputation: +14/-0
Offline Offline

Posts: 52



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  
Data Warehousing Community Forum > Databases > Teradata > Topic: System tables/views in Teradata
 « previous next »
 
Jump to:  



© Copyright 2006-2010 DW Forum. All rights reserved

contactSanghala | Cyber Militia | Powered by SMF | SMF © 2006-2009, Simple Machines LLC | Dilber MC Theme by HarzeM