`information_schema.views.is_updatable`

mysql

type: ENUM NULL

type: VARCHAR NOT NULL

5.7

type: NULL

Note:

Whether the view is updatable or not.

5.1-10.8

type: VARCHAR NOT NULL

Note:

Whether the view is updatable or not.

type: VARCHAR(3) NOT NULL

Note:

Whether UPDATE/INSERT/DELETE is applicable to the view. In TiDB, the value is always NO.

4-6.1

type: YES_OR_NO NULL

Note:

YES if the view is updatable (allows UPDATE and DELETE), NO if not

10-15

type: CHARACTER_DATA

Note:

YES if the view is updatable (allows UPDATE and DELETE), NO if not

8.2-9.6

Note:

Not yet implemented

7.4-8.1

type: unknown

Note:

Always NULL (unsupported by CockroachDB).

1-21.2

type: VARCHAR(2) NULL

Note:

Specifies whether the view is updatable. Always returns NO.