apache / apache/arrow-adbc

format: expose more metadata about foreign keys

Open
#3,989 0 comments 0 reactions 1 assignee Claimed by @lidavidm View on GitHub
Type: enhancement
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.