Search code examples
mysqlddltable-relationshipseer-model

How do I see the EER Model for an mySQL database I have created using DDL

I've created a new schema/database in DDL query thing in MySQL Work Bench. (I hope I explain myself well enough since I can't post images without 10 Rep apparently... Like the code below sort of stuff).

CREATE DATABASE  IF NOT EXISTS `bicycle_rental`;
USE `bicycle_rental`;

CREATE TABLE `Bicycles`
(
    `id_bicycles` int NOT NULL DEFAULT '0',
    `bicycle_details` varchar(45),
    PRIMARY KEY (`id_bicycles`)
);

But I can't figure out how to make it appear in the visual table like an EER model so I can see the relationships and all that.

Is there a way this can be done?

Solution

  • For MySQL Workbench when you fire the application, there should be a way for you to create a new EER Model from an existing database. Once you choose that option, you should be able to go through a wizard that guides you through the process.

    Here is a helpful video.