HANA list / show tables SQL Command

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.