Something about DataStage, DataStage Administration, Job Designing,Developing, DataStage troubleshooting, DataStage Installation & Configuration, ETL, DataWareHousing, DB2, Teradata, Oracle and Scripting.
Tuesday, July 02, 2013
List the tables in TeraData
For listing all the tables, views and macro , execute any sql from below as per need
select * from dbc.tables;
select * from dbc.tables where databasename='<DB_name>';
select tablename from dbc.tables where databasename='<DB_name>' and tablekind='<Table_type>';
select databasename, tablename from dbc.tables where databasename in (‘<list of DBs>’) order by databasename;