For listing all the tables, views and macro , execute any sql from below as per need
a) select * from
dbc.tables;
b) select * from dbc.tables
where databasename='<DB_name>';
c) select tablename from dbc.tables where databasename='<DB_name>' and
tablekind='<Table_type>';
d) select databasename, tablename from dbc.tables where databasename in (‘<list
of DBs>’) order by databasename;
