Unanswered: How to create a foreign key to a table from metaschema ?
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.