How can I get database design from a existing database

user_17527730 0
Viewed 39

I am using WAMP. In phpMyAdmin I created database without any model (database is pretty simple) and now I need to show structure of database but I do not know how. The closest one I got is Designer tab in phpMyAdmin, but there are not relations (look at image). I tried to add them manually but I got error Relation features are disabled. I am not 100% sure but I think my db is already using InnoDB image

phpmyadmin
1 Answers

Looks like your tables uses non-relational engine.

Check the engine for each table with SHOW CREATE TABLE tablename; statement. If you do not see ENGINE=InnoBD at the end of the script then ater the table's engine with ALTER TABLE tablename ENGINE = InnoDB;.

user_101387340
Related