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

SELECT
  NULLIF(1, 1) AS TABLE_CATALOG,
  LTRIM(RTRIM(SYSCAT.TABLES.TABSCHEMA)) AS TABLE_SCHEMA,
  LTRIM(RTRIM(SYSCAT.TABLES.TABNAME)) AS TABLE_NAME,
  SYSCAT.TABLES.CREATE_TIME,
  SYSCAT.TABLES.ALTER_TIME,
  LTRIM(RTRIM(SYSCAT.TABLESPACES.TBSPACE)) AS TABLE_SPACE
FROM
  SYSCAT.TABLES
  INNER JOIN SYSCAT.TABLESPACES
    ON SYSCAT.TABLES.TBSPACEID = SYSCAT.TABLESPACES.TBSPACEID
WITH UR