distal-attribute
distal-attribute
distal-attribute
distal-attribute

Schema Designer

pankaj_it09 posted 3 years ago in Feature discussion
Is there any schema designer inside HeidiSQL ?
ansgar posted 3 years ago
Of course. See the table editor.

Right click in a database > Create new > Table
pankaj_it09 posted 3 years ago
Actually I want the snapshot of all the tables selected by me. Also some arrow buttons to show the relation between them.
ansgar posted 3 years ago
A "snapshot" is an SQL export in my understandings. This can be done with the "Export database" dialog.

There is no GUI in Heidi which shows relations between tables. Only a list of tables, triggers, views and whatever.
pankaj_it09 posted 3 years ago
No I don't want to export. I just want a image snapshot of the tables selected by me.
Image snapshot should have the table name, all the fields and their types.
ansgar posted 3 years ago
Well that's basically what the "Database" tab shows you. Just try it out.
kalvaro posted 3 years ago
I suspect you are asking for a graphical tool to draw entity-relation diagrams. HeidiSQL does not have any.
jfalch posted 3 years ago
try MySQL WorkBench
pankaj_it09 posted 3 years ago
kalvaro

Yes you are nearly right.

Actually I need a canvas like area where I can drop the tables after dragging them.
jfalch posted 3 years ago
that is what MySQL Workbench does (albeit only for db engines that support foreign keys, like InnoDB).
pankaj_it09 posted 3 years ago
OK.

What about for MyISAM ?
jfalch posted 3 years ago
generally not possible for MyISAM, since it does not store/keep foreign key references.
pankaj_it09 posted 3 years ago
OK got it.

Does it has the arrow graphics so that I can drag the arrows and connect tables ?
BubikolRamios posted 3 years ago
I was trying the other day MySQL Workbench, got nowhere, trying to draw db diagram. If it works it is less than intuitive. Try with toad for mysql. There it works all right at begining. It eats resources, far more tham HeidiSQL, but with fast machine should do.
pankaj_it09 posted 3 years ago
OK.

Please login to leave a reply, or register at first.