Just wondering if there is someone here who have created a SQL to extract the definitions of all the Tables, Views, Macro etc.
you can run
select 'show ' !! case when tablekind = 'm' then 'macro' when tablekind = 't' then 'table' when tablekind = 'v' then 'view' end !! ' ' !! trim(databasename) !! '.' !! trim(tablename) !! ';'
where tablekind in ('T','V','M');
and run the generated SQLs afterwards.