• Home
• us.fatehi
• schemacrawler-db2
• 16.24.2
• source code
• TABLE_CONSTRAINTS.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.TABLE_CONSTRAINTS.sql Maven / Gradle / Ivy

SELECT
  NULLIF(1, 1) AS CONSTRAINT_CATALOG,
  STRIP(SYSIBM.TABLE_CONSTRAINTS.CONSTRAINT_SCHEMA) AS CONSTRAINT_SCHEMA,
  STRIP(SYSIBM.TABLE_CONSTRAINTS.CONSTRAINT_NAME) AS CONSTRAINT_NAME,
  NULLIF(1, 1) AS TABLE_CATALOG,
  STRIP(SYSIBM.TABLE_CONSTRAINTS.TABLE_SCHEMA) AS TABLE_SCHEMA,
  STRIP(SYSIBM.TABLE_CONSTRAINTS.TABLE_NAME) AS TABLE_NAME,
  STRIP(SYSIBM.TABLE_CONSTRAINTS.CONSTRAINT_TYPE) AS CONSTRAINT_TYPE,
  STRIP(SYSIBM.TABLE_CONSTRAINTS.IS_DEFERRABLE) AS IS_DEFERRABLE,
  STRIP(SYSIBM.TABLE_CONSTRAINTS.INITIALLY_DEFERRED) AS INITIALLY_DEFERRED
FROM
  SYSIBM.TABLE_CONSTRAINTS
ORDER BY
  SYSIBM.TABLE_CONSTRAINTS.TABLE_SCHEMA,
  SYSIBM.TABLE_CONSTRAINTS.TABLE_NAME
WITH UR