• Home
• us.fatehi
• schemacrawler-sqlserver
• 16.22.3
• 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.

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

SELECT
  TABLE_CATALOG,
  TABLE_SCHEMA,
  TABLE_NAME,
  CHECK_OPTION,
  IS_UPDATABLE,
  OBJECT_DEFINITION(OBJECT_ID(TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME))
    AS VIEW_DEFINITION
FROM
  INFORMATION_SCHEMA.VIEWS