Get metadata of tables in hive metastore

[DatabricksPract]

Hi team,

I have a requirement to get the metadata of tables available in databricks hive metastore.

Is there any way to get the metadata of all the tables inspite of looping through tables using Describe table_name.

As hive metastore doesnot support information schema, please suggest if we have any other approaches.

Thanks in advance,

[Tharun-Kumar · Accepted solution]

@DatabricksPract 

You can use 

%sql
show table extended in <database_name> like '*'

This would give the information of the all the tables in the database provided.

[DatabricksPract]

@Tharun-Kumar - Thanks for your quick reply, it worked.