`information_schema.views.check_option`

mysql

type: ENUM NULL

type: VARCHAR NOT NULL

5.7

type: NULL

Note:

YES if the WITH CHECK_OPTION clause has been specified, NO otherwise.

5.1-10.8

type: VARCHAR NOT NULL

Note:

YES if the WITH CHECK_OPTION clause has been specified, NO otherwise.

type: VARCHAR(8) NOT NULL

Note:

The CHECK_OPTION value. The value options are NONE, CASCADE, and LOCAL.

4-6.1

type: CHARACTER_DATA NULL

Note:

CASCADED or LOCAL if the view has a CHECK OPTION defined on it, NONE if not

10-15

type: CHARACTER_DATA

Note:

CASCADED or LOCAL if the view has a CHECK OPTION defined on it, NONE if not

9.4-9.6

Note:

Applies to a feature not available in PostgreSQL

7.4-9.3

type: unknown

Note:

Always NULL (unsupported by CockroachDB).

1-21.2

type: VARCHAR(7) NULL

Note:

Type of WITH CHECK OPTION. Is CASCADE if the original view was created by using the WITH CHECK OPTION. Otherwise, NONE is returned.