On 11/15/06, LeO Welsch <le...@gm...> wrote:
>
> -------- Original-Nachricht --------
> Datum: Tue, 14 Nov 2006 17:33:25 -0500
> Von: "Robert Manning" <rob...@gm...>
> An: "Gerd Wagner" <bir...@t-...>
> Betreff: Re: [Squirrel-sql-users] Graph- how to use?
>
> > On 11/14/06, Gerd Wagner <bir...@t-...> wrote:
>
> Currently not possible, as well not in near future. A refactoring Plugin is currently developed, which would provide that kind of functionallity. The purpose of this plugin is for Developers of Squirrel only. The Graph would provide this feature, if Constrainsts would be addable (through the refactoring Plugin) in the Graph-View.
Yes, with the exception that the refactoring plugin is intended for
users of SQuirreL.
>
> MY understanding from the Graph was that it is merley for visualization and not so much for adding constraints and references to the Table. And therefore I am interested to add as Visualization the logical connections.
>
> Since I have little bit different understanding about how the Graph is currently used, I am interested in what is the purpose of this view? *Only* to display some tables and due to some internal mechanism a relationship is generated? Cause the context-menu with 'Add ... tables' does not work as well. And ordering the names of a DB might be helpful, but ...
>
Sure, but as I have used it, I thought I can remember that it uses
foreign keys to render dependency lines between fields in the tables.
So, a child column which is a member of a foreign key to a parent
primary key column in a different table will be shown on the graph
when both tables are added in such a way that the child column has a
line with an arrow pointing to the parent column. So, if you want to
have the graph plugin show relationships visually, you must - for the
foreseeable future - define foreign keys using regular SQL in
SQuirreL. Sorry if this all wasn't clear from our conversation. If
you have any other questions, feel free to ask.
Rob
|