Search code examples
mysqldatabasedatabase-designphpmyadmininformation-schema

how can i make relation between INFORMATION_SCHEMA.TABLES and other table

is it possible to make relation between INFORMATION_SCHEMA.TABLES and get TABLE_NAME and add it to other table

i want to make table has all the tables name and another table has all the field name

i need this table to make table have all tables name and another table has all fields name

Solution

  • No. What you ask isn't possible.

    INFORMATION_SCHEMA isn't a normal sort of table that you can add constraints, triggers or other modification constants to. Its there to be read only.