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;