Schema Designer

[expired user #5933]'s profile image [expired user #5933] posted 13 years ago in Feature discussion Permalink
Is there any schema designer inside HeidiSQL ?
ansgar's profile image ansgar posted 13 years ago Permalink
Of course. See the table editor.

Right click in a database > Create new > Table
[expired user #5933]'s profile image [expired user #5933] posted 13 years ago Permalink
Actually I want the snapshot of all the tables selected by me. Also some arrow buttons to show the relation between them.
ansgar's profile image ansgar posted 13 years ago Permalink
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.
[expired user #5933]'s profile image [expired user #5933] posted 13 years ago Permalink
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's profile image ansgar posted 13 years ago Permalink
Well that's basically what the "Database" tab shows you. Just try it out.
kalvaro's profile image kalvaro posted 13 years ago Permalink
I suspect you are asking for a graphical tool to draw entity-relation diagrams. HeidiSQL does not have any.
jfalch's profile image jfalch posted 13 years ago Permalink
try MySQL WorkBench
[expired user #5933]'s profile image [expired user #5933] posted 13 years ago Permalink
kalvaro

Yes you are nearly right.

Actually I need a canvas like area where I can drop the tables after dragging them.
jfalch's profile image jfalch posted 13 years ago Permalink
that is what MySQL Workbench does (albeit only for db engines that support foreign keys, like InnoDB).
[expired user #5933]'s profile image [expired user #5933] posted 13 years ago Permalink
OK.

What about for MyISAM ?
jfalch's profile image jfalch posted 13 years ago Permalink
generally not possible for MyISAM, since it does not store/keep foreign key references.
[expired user #5933]'s profile image [expired user #5933] posted 13 years ago Permalink
OK got it.

Does it has the arrow graphics so that I can drag the arrows and connect tables ?
BubikolRamios's profile image BubikolRamios posted 13 years ago Permalink
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.
[expired user #5933]'s profile image [expired user #5933] posted 13 years ago Permalink
OK.

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