`information_schema.tables.table_type`

mysql

type: ENUM NOT NULL

5.7-8

mariadb

type: NULL

Note:

One of BASE TABLE for a regular table, VIEW for a view, SYSTEM VIEW for Information Schema tables, SYSTEM VERSIONED for system-versioned tables or SEQUENCE for sequences.

5.1-10.8

type: VARCHAR NOT NULL

Note:

One of BASE TABLE for a regular table, VIEW for a view, SYSTEM VIEW for Information Schema tables, SYSTEM VERSIONED for system-versioned tables or SEQUENCE for sequences.

10.2-10.7

tidb

type: VARCHAR(64) NULL

Note:

The type of the table.

4-6.1

postgres

type: CHARACTER_DATA NULL

Note:

Type of the table: BASE TABLE for a persistent base table (the normal table type), VIEW for a view, FOREIGN for a foreign table, or LOCAL TEMPORARY for a temporary table

11-15

Note:

Type of the table: BASE TABLE for a persistent base table (the normal table type), VIEW for a view, FOREIGN TABLE for a foreign table, or LOCAL TEMPORARY for a temporary table

type: CHARACTER_DATA

Note:

Type of the table: BASE TABLE for a persistent base table (the normal table type), VIEW for a view, FOREIGN TABLE for a foreign table, or LOCAL TEMPORARY for a temporary table

9.1-9.6

Note:

Type of the table: BASE TABLE for a persistent base table (the normal table type), VIEW for a view, or LOCAL TEMPORARY for a temporary table

7.4-9

cockroachdb

type: unknown

Note:

Type of the table: BASE TABLE for a normal table, VIEW for a view, or SYSTEM VIEW for a view created by CockroachDB.

1-21.2

mssql

type: VARCHAR(10) NULL

Note:

Type of table. Can be VIEW or BASE TABLE.

aps-pdw-2016-sql-server-ver15