1
show create table data_dictionary.innodb_table_definitions;
3
innodb_table_definitions CREATE TABLE `innodb_table_definitions` (
4
`table_name` varbinary(192) DEFAULT NULL,
6
PRIMARY KEY (`table_name`) USING BTREE
8
select * from data_dictionary.innodb_table_definitions;
11
show tables like 'innodb%';
12
Tables_in_data_dictionary (innodb%)
13
innodb_table_definitions
15
create table t1 (a int primary key);
16
select table_name from data_dictionary.innodb_table_definitions;
20
select count(table_name) from data_dictionary.innodb_table_definitions;