Menu

#460 For a self-referencing table does not shows it the edge

General
open
5
2012-12-29
2012-10-10
Pedro
No

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).

Discussion


Log in to post a comment.