Column name
|
Data type
|
Description
|
| TABLE_CATALOG |
VARCHAR(128) |
The name of the catalog containing the table or view. |
| TABLE_SCHEMA |
VARCHAR(128) |
The name of the schema containing the table or view. |
| TABLE_NAME |
VARCHAR(128) |
The name of the table or view. |
| VIEW_DEFINITION |
VARCHAR(2000) |
The definition of the view as it would appear in a CREATE VIEW statement. If the actual definition would not fit into the maximum length of this column, the NULL value will be shown. |
| CHECK_OPTION |
VARCHAR(20) |
The value "CASCADED" is shown if WITH CHECK OPTION was specified in the CREATE VIEW statement that created the view, and the value "NONE" is shown otherwise. |
| IS_UPDATABLE |
VARCHAR(3) |
One of:
"YES" = the view is updatable
"NO" = the view is not updatable. |
