where are the infos from 'SHOW CREATE TABLE' coming from? It's not INFORMATION_SCHEMA
Quote from MariaDB 10.2 CHECK and DEFAULT clauses:
Another limitation is that CHECK metadata are not accessible via the INFORMATION_SCHEMA. The only way to find out if a table has CHECK clauses is parsing the output of SHOW CREATE TABLE.
I also found in MariaDB KB
Note that SHOW CREATE TABLE is not meant to provide metadata about a table. It provides information about how the table was declared, but the real table structure could differ a bit. For example, if an index has been declared as HASH, the CREATE TABLE statement returned by SHOW CREATE TABLE will declare that index as HASH; however, it is possible that the index is in fact a BTREE, because the storage engine does not support HASH.
So from where does
SHOW CREATE TABLE collect its output?