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

Go to download

Show more of this group Show more artifacts with this name
Show all versions of schemacrawler-sqlite Show documentation

There is a newer version: 16.22.2

SELECT
  NULL AS TABLE_CATALOG,
  NULL AS TABLE_SCHEMA,
  name AS TABLE_NAME,
  sql AS VIEW_DEFINITION,
  'UNKNOWN' AS CHECK_OPTION,
  'N' AS IS_UPDATABLE
FROM
  sqlite_master
WHERE
  type = 'view'
ORDER BY
  name