HANA list / show tables SQL Command

sql hana
Thorsten Niehues picture Thorsten Niehues · Jan 18, 2017 · Viewed 44.3k times · Source

How to show / list all tables in SAP HANA via SQL?

Answer

Lars Br. picture Lars Br. · Jan 18, 2017

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.

Related questions

How to convert a string to date in SAP HANA SQL select statement?

How do i convert a string '20120215' to a date format YYYY-MM-DD (2012-02-15) in a SQL SELECT statement? I am using SAP HANA SQL.

Read More
Combine LIKE and CONTAINS in SAP HANA

Consider the following entries in my table: red apple yellow apple apple green red aple appel yellow Several people have populated this table using a non-consistend notation (the color before or after 'apple'), also entering some spelling errors. Now I …

Read More
How to concatenate multiple rows' fields in a sap hana table

I use SAP-HANA database. I have a simple 2 column table whose columns are id, name. The rows are these: 1 - tom 1 - harry 1 - jack 2 - larry I would like to group the rows by the id, and concatenate the …

Read More