information_schema.views.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
views |
||||||||
algorithm |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
character_set_client |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NOT NULL:
| unsupported | unsupported | unsupported | ||
check_option |
VARCHAR NOT NULL:
5.7
ENUM NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(8) NOT NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(7) NULL:
| |||
collation_connection |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NOT NULL:
| unsupported | unsupported | unsupported | ||
definer |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(77) NOT NULL:
| unsupported | unsupported | unsupported | ||
is_insertable_into |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
is_trigger_deletable |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
is_trigger_insertable_into |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
is_trigger_updatable |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
is_updatable |
VARCHAR NOT NULL:
5.7
ENUM NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NOT NULL:
| CHARACTER_DATA:
YES_OR_NO NULL:
| VARCHAR(2) NULL:
| |||
security_type |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(7) NOT NULL:
| unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
view definition |
unsupported | unsupported | unsupported | CHARACTER_DATA:
| unsupported | unsupported | ||
view_definition |
LONGTEXT NOT NULL:
5.7
LONGTEXT NULL:
8
| LONGTEXT NOT NULL:
NULL:
| LONGBLOB NOT NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| NVARCHAR(4000) NULL:
| |||