https://community.cloudera.com/t5/Support-Questions/Query-to-access-all-managed-tables-of-a-given-database-in/m-p/236843#M198656 <P><A rel="user" href="https://community.cloudera.com/users/115696/rohinimathursjc.html" nodeid="115696">@Rohini Mathur</A></P><P><STRONG><U>Using Shell script:</U></STRONG></P><P>one way of doing this would be using Shell script and to get all tables from the database </P><PRE>show tables from &lt;db_name&gt;;</PRE><P>then store all the tables into a variable and then loop through the each variable and execute</P><PRE>show create table &lt;table_name&gt;;</PRE><P>command.</P><HR /><P><STRONG><U>Using Spark:</U></STRONG></P><P>Another way would be</P><P>Using <STRONG>spark.catalog.listtables("&lt;db_name&gt;")</STRONG> to list out all the tables from database then filter out only the managed tables and execute show create table on the list of managed tables..</P><HR /><P><STRONG><U>Using Hive metastore db:</U></STRONG></P><P>Hive stores all the table information in metastore like mysql..etc you can also get information about tables from metastore also.</P> Wed, 31 Jul 2019 09:53:37 GMT Shu_ashu 2019-07-31T09:53:37Z