I want to create tables that will keep some additional data on schemas and tables. And I need referential integrity. So my tables must link to tables from schema information_schema.
The trouble is that those tables are not real tables but views. So usual foreign key cannot be created.

Example. My table schemas must link to table information_schema.SCHEMATA.

What can you propose ?

you can carry on without the foreign keys, yes?

No, without referential integrity system becomes weak.
I search for ways to store information about schemes and tables in some way that keeps referential integrity.

it's funny, isn't it, that millions of other mysql customers are happy with the referential integrity provided by the software right out of the box, and you feel you need to supplement it somehow...

I suppose those millions don't need to store metadata about tables.

yeah, that was my point

you should go ahead and store your metadata if you need to -- nothing wrong with that

that's why i said "you can carry on without the foreign keys, yes?"

i'm not suggesting you do away with foreign keys in your regular database, just none between your metadata and the information_schema tables