VIEWS

This view contains information about the views in a workspace.

Column Name

Description

TABLE_CATALOG

The related catalog for a given view.

TABLE_SCHEMA

The related schema (database) for a given view.

TABLE_NAME

The name of a given view.

VIEW_DEFINITION

The SQL statement used to define a given view.

CHECK_OPTION

This column exists for MySQL compatibility and is always NONE.

IS_UPDATABLE

Whether or not a given view can be updated.

DEFINER

The user who created a given view.

SECURITY_TYPE

This value is always DEFINER.

CHARACTER_SET_CLIENT

The session setting for the character_set_client engine variable when a given view was created.

COLLATION_CONNECTION

The session setting for the collation_connection engine variable when a given view was created.

FLAGS

Whether the view is a Table Valued Function (TVF). IS_TABLE_VALUED_FUNCTION indicates the view is a TVF. Otherwise the value is blank.

Last modified: August 29, 2022

Was this article helpful?