1
show create table data_dictionary.innodb_table_definitions;
3
innodb_table_definitions CREATE TABLE `innodb_table_definitions` (
4
`table_name` VARBINARY(192),
6
PRIMARY KEY (`table_name`) USING BTREE
7
) ENGINE=InnoDB COLLATE = binary
8
select * from data_dictionary.innodb_table_definitions;
11
show tables like 'innodb%';
12
Tables_in_data_dictionary (innodb%)
18
INNODB_SYS_FOREIGN_COLS
21
innodb_table_definitions
23
create table t1 (a int primary key);
24
select table_name from data_dictionary.innodb_table_definitions;
28
select count(table_name) from data_dictionary.innodb_table_definitions;