Hello @rohinimathursjc    The best way to get the list of Hive external tables and Managed tables is using hive metastore. yes by applying some quires on hive metastore tables we can divide both Hive external tables and Managed tables . please follow the below link to get the queries  https://askdoubts.com/question/list-of-hive-internal-tables-from-metadata/#comment-20   ... View more