This view contains the following information on each user-defined or publicly created view:
Column Heading | Definition |
---|---|
table_catalog | Database containing the view |
table_schema | View owner; the owner can be either the current schema (user) viewing the INFORMATION_SCHEMA or the PUBLIC schema |
table_name | Name of the view |
view_definition | SQL that defines the view |