We have moved to www.dataGenX.net, Keep Learning with us.

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;