• Home
• us.fatehi
• schemacrawler-db2
• 16.24.2
• source code
• FOREIGN_KEYS.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db2.information_schema.FOREIGN_KEYS.sql Maven / Gradle / Ivy

SELECT 
  NULLIF(1, 1) AS FK.PKTABLE_CAT,
  FK.PKTABLE_SCHEM,
  FK.PKTABLE_NAME,
  FK.PKCOLUMN_NAME,
  NULLIF(1, 1) AS FK.FKTABLE_CAT,
  FK.FKTABLE_SCHEM,
  FK.FKTABLE_NAME,
  FK.FKCOLUMN_NAME,
  FK.KEY_SEQ,
  FK.UPDATE_RULE,
  FK.DELETE_RULE,
  FK.FK_NAME,
  FK.PK_NAME,
  FK.DEFERRABILITY,
  FK.UNIQUE_OR_PRIMARY
FROM
  SYSIBM.SQLFOREIGNKEYS FK
  INNER JOIN SYSCAT.TABLES T
    ON T.TABSCHEMA = FK.FKTABLE_SCHEM AND T.TABNAME = FK.FKTABLE_NAME
WHERE
  T.TYPE != 'A' -- Do not include imported foreign keys for synonyms   
WITH UR