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

Schema Designer

User, date Message
Written by pankaj_it09
3 years ago
Category: Feature discussion
7 posts since Thu, 22 Sep 11
Is there any schema designer inside HeidiSQL ?
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
Of course. See the table editor.

Right click in a database > Create new > Table
Written by pankaj_it09
3 years ago
7 posts since Thu, 22 Sep 11
Actually I want the snapshot of all the tables selected by me. Also some arrow buttons to show the relation between them.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
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.
Written by pankaj_it09
3 years ago
7 posts since Thu, 22 Sep 11
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.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
Well that's basically what the "Database" tab shows you. Just try it out.
Written by kalvaro
3 years ago
594 posts since Thu, 29 Nov 07
I suspect you are asking for a graphical tool to draw entity-relation diagrams. HeidiSQL does not have any.
Written by jfalchMoney, Euro
3 years ago
388 posts since Sat, 17 Oct 09
try MySQL WorkBench
Written by pankaj_it09
3 years ago
7 posts since Thu, 22 Sep 11
kalvaro

Yes you are nearly right.

Actually I need a canvas like area where I can drop the tables after dragging them.
Written by jfalchMoney, Euro
3 years ago
388 posts since Sat, 17 Oct 09
that is what MySQL Workbench does (albeit only for db engines that support foreign keys, like InnoDB).
Written by pankaj_it09
3 years ago
7 posts since Thu, 22 Sep 11
OK.

What about for MyISAM ?
Written by jfalchMoney, Euro
3 years ago
388 posts since Sat, 17 Oct 09
generally not possible for MyISAM, since it does not store/keep foreign key references.
Written by pankaj_it09
3 years ago
7 posts since Thu, 22 Sep 11
OK got it.

Does it has the arrow graphics so that I can drag the arrows and connect tables ?
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
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.
Written by pankaj_it09
3 years ago
7 posts since Thu, 22 Sep 11
OK.
 

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