Menu
How to show / list all tables in SAP HANA via SQL?
473
When you add a HANA system in HANA Studio, you can see different tabs under system pane. Each pane has different object types of HANA system. To see the list of all schema and tables, you need to navigate to Catalog tab.
Using the MySQL Command Line Client mysql> USE pizza_store; Now use the MySQL SHOW TABLES command to list the tables in the chosen database. mysql> SHOW TABLES; This command returns a list of all the tables in the chosen database.
SAP HANA provides a database catalog (just like most other DBMS) via system tables like TABLES, VIEWS, USERS, etc. ... These are the ANSI-92 compliant metadata views.
Instead of the INFORMATION_SCHEMA SAP HANA provides these views in the PUBLIC schema (again, like other DBMS do that).
Example:
select * from tables
select * from public.tables
The M_TABLES provides information about the runtime objects that represent tables.
55
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
