format: expose more metadata about foreign keys
- Dominant language
- C#
- Stars
- 627
- Forks
- 217
- Avg merge
- 17h
- Merged PRs (30d)
- 57
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](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getExportedKeys-java.lang.String-java.lang.String-java.lang.String-), with fields UPDATE_RULE, DELETE_RULE, DEFERRABILITY
- [ODBC: SQLForeignKeys](https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlforeignkeys-function?view=sql-server-ver17), 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: https://github.com/apache/arrow-adbc/issues/3971 (point 12). Note that there's more info than JDBC/ODBC expose
Contributor guide
Assessment
This issue has not been assessed yet.