• Home
• us.fatehi
• schemacrawler-hana
• 16.23.2
• source code
• CONSTRAINT_COLUMN_USAGE.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.

hana.information_schema.CONSTRAINT_COLUMN_USAGE.sql Maven / Gradle / Ivy

SELECT
  NULL AS CONSTRAINT_CATALOG,
  CONSTRAINTS.SCHEMA_NAME AS CONSTRAINT_SCHEMA,
  CONSTRAINTS.CONSTRAINT_NAME,
  NULL AS TABLE_CATALOG,
  CONSTRAINTS.SCHEMA_NAME AS TABLE_SCHEMA,
  CONSTRAINTS.TABLE_NAME,
  CONSTRAINTS.COLUMN_NAME AS COLUMN_NAME,
  0 AS ORDINAL_POSITION
FROM
  SYS.CONSTRAINTS
ORDER BY
  CONSTRAINTS.SCHEMA_NAME,
  CONSTRAINTS.CONSTRAINT_NAME