Re: [Squirrel-sql-users] Graph- how to use?

[Robert M. <rob...@gm...>]

On 11/14/06, Gerd Wagner <bir...@t-...> wrote:
> LeO Welsch wrote:
> > Hi,
> >
> > I have added several tables on the Graph and now I wanna add
>  > the relation, but the context-menu does not indicate how to do
>  > this. The Menu-Item 'add table referenced by (no hit on FK)'
>  > is grayed out. Is there a way to add it manually?
>  > Or what have I done the wrong way?
> No there is no way to change things in the database from within a Graph right
> now. One day I'll implement it but not in the near future.
>
> Sorry
>
> Gerd
>
> P.S.: If anyone feels like doing it first. Please go ahead I'll be of any help I
> can.

There is work being done at the moment on a plugin (Refactoring) whose
goal is to make typical refactorings (such as adding a foreign key,
among others) possible with a number of different database dialects.
The work that is being done leverages (and extends) Hibernate's
mechanism for generating correct SQL according to the dialect of SQL
for the database that SQuirreL is connected to.  It will be some time
(not even going to speculate at the moment) but
adding/modifying/dropping constraints are definitely planned.  My
intent here is just a little notification in case someone has decided
to run off and implement this, that there is a framework in place to
accomodate this functionality.  And we should probably coordinate
efforts rather than duplicate them.

Rob