How to show / list all tables in SAP HANA via SQL?
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).
select * from tables
select * from public.tables
The M_TABLES provides information about the runtime objects that represent tables.