content_image/818339.jpg
SHOW TABLE STATUS FROM db_name [LIKE ’ wild ’] 

The following statements are equivalent: 

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 ’] 

## 26.3.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table 

The TABLES_EXTENSIONS  table (available as of MySQL 8.0.21) provides information about table attributes defined for primary and secondary storage engines. 

<img src='content_image/818339.jpg'>

The TABLES_EXTENSIONS  table has these columns: 

• TABLE_CATALOG 

The name of the catalog to which the table belongs. This value is always def . 

• TABLE_SCHEMA 

The name of the schema (database) to which the table belongs. 

• TABLE_NAME 

The name of the table. 

• ENGINE_ATTRIBUTE 

Table attributes defined for the primary storage engine. Reserved for future use. 

• SECONDARY_ENGINE_ATTRIBUTE 

## Note 

The TABLES_EXTENSIONS  table is reserved for future use. 

Table attributes defined for the secondary storage engine. Reserved for future use. 

## 26.3.40 The INFORMATION_SCHEMA TABLESPACES Table 

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 NDB , the INFORMATION_SCHEMA FILES  table provides tablespace-related information. 

•For InnoDB , the INFORMATION_SCHEMA INNODB_TABLESPACES  and INNODB_DATAFILES  tables provide tablespace metadata. 

## 26.3.41 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table 

