On 08.10.2012 10:49, Pedro Pastor wrote:
> Steps to reproduce the problem:
> #
> Execute the following SQL sentence against any database:
> create table Employee(
> id integer not null primary key,
> name varchar(50) not null,
> bossId integer,
> foreign key (bossId) references Employee(id)
> )
> #
> Open SQuirreL, connect to the database, and open the graph
> diagram of "Employee" table.
>
> The problem:
> The corresponding SQuirreL's graph diagram to that
> table does NO show the edge between an employee
> ("bossId" column) and itself ("id" column).
I confirm that SQuirreL cannot show self-referencing foreign keys yet.
You may file a feature request for it here
http://sourceforge.net/tracker/?atid=393417&group_id=28383
Gerd
|