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

SELECT
  NULLIF(1, 1) AS SYNONYM_CATALOG,
  LTRIM(RTRIM(TABSCHEMA)) AS SYNONYM_SCHEMA,
  LTRIM(RTRIM(TABNAME)) AS SYNONYM_NAME,
  NULLIF(1, 1) AS REFERENCED_OBJECT_CATALOG,
  LTRIM(RTRIM(BASE_TABSCHEMA)) AS REFERENCED_OBJECT_SCHEMA,
  LTRIM(RTRIM(BASE_TABNAME)) AS REFERENCED_OBJECT_NAME
FROM
  SYSCAT.TABLES
WHERE
  TYPE = 'A'
WITH UR