How to get all the dbc.% tables in Teradata

Database
N/A

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?

2 REPLIES
N/A

Re: How to get all the dbc.% tables in Teradata

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

Re: How to get all the dbc.% tables in Teradata

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