views

TABLE_CATALOG

varchar(512)

Name of the catalog (database) to which the view belongs. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.

TABLE_SCHEMA

varchar(64)

Name of the schema to which the view belongs. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.

TABLE_NAME

varchar(64)

Name of the view. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.

VIEW_DEFINITION

longtext

Statement that provides the definition of the view.

CHECK_OPTION

varchar(8)

Value of the check_option attribute. The value is NONE, CASCADE, or LOCAL.

IS_UPDATABLE

varchar(3)

Specifies whether the view can be updated.

DEFINER

varchar(93)

This column is not supported in the current version, and it is null.

SECURITY_TYPE

varchar(7)

This column is not supported in the current version, and it is null.

CHARACTER_SET_CLIENT

varchar(32)

This column is not supported in the current version, and it is null.

COLLATION_CONNECTION

varchar(32)

This column is not supported in the current version, and it is null.