views

views provides information about all user-defined views.

The following fields are provided in views:

Field	Description
TABLE_CATALOG	The name of the catalog to which the view belongs. This value is always def.
TABLE_SCHEMA	The name of the database to which the view belongs.
TABLE_NAME	The name of the view.
VIEW_DEFINITION	The SELECT statement that provides the definition of the view.
CHECK_OPTION	The value of the CHECK_OPTION attribute. The value is one of NONE, CASCADE, or LOCAL.
IS_UPDATABLE	Whether the view is updatable. The flag is set to YES (true) if UPDATE and DELETE (and similar operations) are legal for the view. Otherwise, the flag is set to NO (false). If a view is not updatable, statements such UPDATE, DELETE, and INSERT are illegal and are rejected.
DEFINER	The user of the user who created the view.
SECURITY_TYPE	The view SQL SECURITY characteristic. The value is one of DEFINER or INVOKER.
CHARACTER_SET_CLIENT
COLLATION_CONNECTION