how to get information about foreign key constraints (was: foreign key constraints not being added on create table node neo)

[delebash]

node neo
windows 11
node v24.5.0
"@duckdb/node-api": "^1.3.2-alpha.25"

index.js

import  {DuckDBInstance} from '@duckdb/node-api';

async function test() {

//Create connection
    const instance = await DuckDBInstance.create('./database/my_duckdb.db');
    const connection = await instance.connect();

//Create tables with foreign key
    await connection.run(
        'CREATE TABLE t1 (id INTEGER PRIMARY KEY, j VARCHAR);\n' +
        'CREATE TABLE t2 (\n' +
        '    id INTEGER PRIMARY KEY,\n' +
        '    t1_id INTEGER,\n' +
        '    FOREIGN KEY (t1_id) REFERENCES t1 (id)\n' +
        ');' +
        'INSERT INTO t1 VALUES (1, \'a\');\n' +
        'INSERT INTO t2 VALUES (1, 1)'
    )
}

//Get results
let data =await connection.runAndReadAll('DESCRIBE t2')
console.log(await data.getRowObjects());

await test()

Results for t2 table that has foreign key

[
  {
    column_name: 'id',
    column_type: 'INTEGER',
    null: 'NO',
    key: 'PRI',
    default: null,
    extra: null
  },
  {
    column_name: 't1_id',
    column_type: 'INTEGER',
    null: 'YES',
    key: null,
    default: null,
    extra: null
  }
]

[jraymakers]

The describe output matches the DuckDB CLI:

DuckDB v1.3.2 (Ossivalis) 0b83e5d2f6
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D create table t1 (id integer primary key, j varchar);
D create table t2 (id integer primary key, t1_id integer, foreign key (t1_id) references t1 (id));
D describe t2;
┌─────────────┬─────────────┬─────────┬─────────┬─────────┬─────────┐
│ column_name │ column_type │  null   │   key   │ default │  extra  │
│   varchar   │   varchar   │ varchar │ varchar │ varchar │ varchar │
├─────────────┼─────────────┼─────────┼─────────┼─────────┼─────────┤
│ id          │ INTEGER     │ NO      │ PRI     │ NULL    │ NULL    │
│ t1_id       │ INTEGER     │ YES     │ NULL    │ NULL    │ NULL    │
└─────────────┴─────────────┴─────────┴─────────┴─────────┴─────────┘

What results or behavior do you expect?

[delebash]

I was looking for the output to show the foreign key relationship. Is there another query I need to run to get the relationship details?

[jraymakers]

See https://duckdb.org/docs/stable/sql/meta/information_schema#constraint_column_usage-constraint-column-usage

[delebash]

Awesome, thank you!