mysql.information_schema.VIEW_TABLE_USAGE.sql Maven / Gradle / Ivy

Go to download

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

There is a newer version: 16.22.3

SELECT
  VIEW_SCHEMA AS VIEW_CATALOG,
  NULL AS VIEW_SCHEMA,
  VIEW_NAME,
  TABLE_SCHEMA AS TABLE_CATALOG,
  NULL AS TABLE_SCHEMA,
  TABLE_NAME
FROM
  INFORMATION_SCHEMA.VIEW_TABLE_USAGE
ORDER BY
  VIEW_SCHEMA,
  VIEW_NAME,
  TABLE_NAME