Foreign key to another table

BigQueryDb2 (LUW)DuckDBH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite2007200920112013201520172019202120232025⚠ 3.31.0 - 3.53.0d⊘ 2008R2 - 2025⚠ 18b✓ 12 - 17✓ 11gR1 - 23.26.2⚠ 9.0 - 9.7.0a⚡ 5.7 - 8.4ab⚠ 10.5 - 12.3.2a⚡ 10.2 - 10.4c⚡ 10.0.10 - 10.1a⚡ 5.2 - 5.5.23✓ 1.4.191 - 2.4.240⊘ 1.0.0 - 1.5.0✓ 9.7 - 12.1.5
  1. aForeign keys in the column definition are parsed but ignored
  2. bOnly with storage option stored
  3. cAs table constraint, not inside the column definition
  4. dOnly without explicit data type: col_name integer generated always as …