MariaDB [test]> select * from information_schema.tables where temporary='y'\G

   TABLE_CATALOG: def

    TABLE_SCHEMA: information_schema

      TABLE_NAME: INNODB_FT_DELETED

      TABLE_TYPE: SYSTEM VIEW

          ENGINE: MEMORY

         VERSION: 11

      ROW_FORMAT: Fixed

      TABLE_ROWS: NULL

  AVG_ROW_LENGTH: 9

     DATA_LENGTH: 0

 MAX_DATA_LENGTH: 9437184

    INDEX_LENGTH: 0

       DATA_FREE: 0

  AUTO_INCREMENT: NULL

     CREATE_TIME: 2020-11-17 21:54:02

     UPDATE_TIME: NULL

      CHECK_TIME: NULL

 TABLE_COLLATION: utf8_general_ci

        CHECKSUM: NULL

  CREATE_OPTIONS: max_rows=1864135

   TABLE_COMMENT: 

MAX_INDEX_LENGTH: 0

       TEMPORARY: Y

79 rows in set (0.011 sec)

MariaDB [test]> show create table information_schema.INNODB_FT_DELETED;

+-------------------+-------------------------------------------------------------------------------------------------------------------------------------+

| Table             | Create Table                                                                                                                        |

+-------------------+-------------------------------------------------------------------------------------------------------------------------------------+

| INNODB_FT_DELETED | CREATE TEMPORARY TABLE `INNODB_FT_DELETED` (

  `DOC_ID` bigint(21) unsigned NOT NULL DEFAULT 0

) ENGINE=MEMORY DEFAULT CHARSET=utf8 |

+-------------------+-------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.000 sec)