List foreign keys on a table
hana_list_foreign_keysList all foreign keys for a given table, including referencing column, referenced table/column, and delete rule. Use to understand table relationships and referential integrity in SAP HANA.
Instructions
List referential constraints (foreign keys) showing column, referenced table/column, and delete rule from SYS.REFERENTIAL_CONSTRAINTS.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | Table name | |
| schema_name | No | Schema name (defaults to HANA_SCHEMA) | |
| catalog_database | No | MDC catalog database for SYS.* |