format: expose more metadata about foreign keys #3989
Description
What feature or improvement would you like to see?
We describe the relationship but not things like ON DELETE CASCADE that JDBC and ODBC expose.
- JDBC: getExportedKeys, with fields UPDATE_RULE, DELETE_RULE, DEFERRABILITY
- ODBC: SQLForeignKeys, with fields UPDATE_RULE, DELETE_RULE, DEFERRABILITY
- Databricks: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-table-constraint
- PostgreSQL: Feature Request: [postgresql] Comprehensive Metadata Discovery for Data Development Tools #3971 (point 12). Note that there's more info than JDBC/ODBC expose