All Forums Database
rads 17 posts Joined 07/08
19 Sep 2011
How to get all the dbc.% tables in Teradata

Is there any way to know what are all the dbc.% tables present in Teradata.

I know only few dbc tables in teradata. Is there anyway to know this?

Karam 75 posts Joined 07/09
19 Sep 2011

SELECT TABLENAME FROM DBC.TABLES WHERE DATABASENAME = 'DBC' AND TABLEKIND = 'T' ;

Run above command to list all DBC tables.

You should have read access on view DBC.TABLES so as to run the query though !!

Jim Chapman 449 posts Joined 09/04
19 Sep 2011

All DBC tables are system tables.  You can read about them in  the Teradata documentation set.  See the volumes titled "Data Dictionary" and "Data Dictionary Quick Reference".

You must sign in to leave a comment.