| Column | Type | Null | Default | Links to | Comments |
|---|---|---|---|---|---|
| TABLE_CATALOG | varchar(512) | No | |||
| TABLE_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
| TABLE_NAME | varchar(64) | No | |||
| VIEW_DEFINITION | longtext | No | |||
| CHECK_OPTION | varchar(8) | No | |||
| IS_UPDATABLE | varchar(3) | No | |||
| DEFINER | varchar(77) | No | |||
| SECURITY_TYPE | varchar(7) | No | |||
| CHARACTER_SET_CLIENT | varchar(32) | No | CHARACTER_SETS -> CHARACTER_SET_NAME | ||
| COLLATION_CONNECTION | varchar(32) | No | COLLATIONS -> COLLATION_NAME |