List tables in schema
hana_list_tablesList tables in a SAP HANA schema, filter by name prefix, and paginate results. Specify schema or catalog database to access metadata across MDC tenants.
Instructions
List tables in a schema with optional name prefix and pagination (HANA_LIST_DEFAULT_LIMIT / offset).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max tables to return (capped by server) | |
| offset | No | Skip this many tables (paging) | |
| prefix | No | Optional table name prefix filter (SQL LIKE prefix%) | |
| schema_name | No | Name of the schema to list tables from (optional) | |
| catalog_database | No | Optional HANA database name whose SYS.TABLES catalog to read (MDC cross-tenant). Omit for connected DB. Overrides HANA_METADATA_CATALOG_DATABASE when set. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| items | Yes | ||
| returned | Yes | ||
| truncated | Yes | ||
| nextOffset | No | ||
| totalAvailable | Yes |