The INFORMATION_SCHEMA TABLES_EXTENSIONS Table SHOW TABLE STATUS FROM  db_name [LIKE ’ wild ’] SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = ’ db_name ’ [AND table_name LIKE ’ wild ’] SHOW FULL TABLES FROM  db_name [LIKE ’ wild ’] 4830 26.3.41 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table 26.3.40 The INFORMATION_SCHEMA TABLESPACES Table 26.3.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table Note The following statements are equivalent: The  TABLES_EXTENSIONS  table (available as of MySQL 8.0.21) provides information about table attributes defined for primary and secondary storage engines. The  TABLES_EXTENSIONS  table is reserved for future use. The  TABLES_EXTENSIONS  table has these columns: The name of the catalog to which the table belongs. This value is always  def . The name of the schema (database) to which the table belongs. The name of the table. Table attributes defined for the primary storage engine. Reserved for future use. Table attributes defined for the secondary storage engine. Reserved for future use. This table is unused. It is deprecated; expect it to be removed in a future MySQL release. Other INFORMATION_SCHEMA  tables may provide related information: •For  InnoDB , the  INFORMATION_SCHEMA INNODB_TABLESPACES  and  INNODB_DATAFILES  tables provide tablespace metadata. •For  NDB , the  INFORMATION_SCHEMA FILES  table provides tablespace-related information. • SECONDARY_ENGINE_ATTRIBUTE • ENGINE_ATTRIBUTE • TABLE_NAME • TABLE_SCHEMA • TABLE_CATALOG