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