Schema Designer
| User, date | Message |
|---|---|
|
Written by pankaj_it09
2 years ago Category: Feature discussion 7 posts since Thu, 22 Sep 11 |
Is there any schema designer inside HeidiSQL ? |
|
Written by ansgar
2 years ago 4027 posts since Fri, 07 Apr 06 |
Of course. See the table editor. Right click in a database > Create new > Table |
|
Written by pankaj_it09
2 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
2 years ago 4027 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
2 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
2 years ago 4027 posts since Fri, 07 Apr 06 |
Well that's basically what the "Database" tab shows you. Just try it out. |
|
Written by kalvaro
2 years ago 457 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 jfalch
2 years ago 241 posts since Sat, 17 Oct 09 |
try MySQL WorkBench |
|
Written by pankaj_it09
2 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 jfalch
2 years ago 241 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
2 years ago 7 posts since Thu, 22 Sep 11 |
OK. What about for MyISAM ? |
|
Written by jfalch
2 years ago 241 posts since Sat, 17 Oct 09 |
generally not possible for MyISAM, since it does not store/keep foreign key references. |
|
Written by pankaj_it09
2 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
2 years ago 275 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
2 years ago 7 posts since Thu, 22 Sep 11 |
OK. |
|
Please login to leave a reply, or register at first. |