• Home
• us.fatehi
• schemacrawler-derby
• 14.03.03
• source code
• VIEWS.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.

derby.information_schema.VIEWS.sql Maven / Gradle / Ivy

SELECT
  CASE WHEN 1=1 THEN NULL ELSE NULL END AS TABLE_CATALOG,
  S.SCHEMANAME AS TABLE_SCHEMA,
  T.TABLENAME AS TABLE_NAME,
  V.VIEWDEFINITION AS VIEW_DEFINITION,
  V.CHECKOPTION AS CHECK_OPTION,
  'NO' AS IS_UPDATABLE
FROM
  SYS.SYSVIEWS V,
  SYS.SYSTABLES T,
  SYS.SYSSCHEMAS S
WHERE
  V.TABLEID = T.TABLEID
  AND S.SCHEMAID = T.SCHEMAID