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;