Menu

#124 FK's on views not detected

open
5
2010-12-31
2010-12-31
Michael M
No

Using an Oracle database, I am creating FK's on views. E.g.:
alter view addresses_v add constraint fk1 foreign key (pers_id) references persons_v (id) disable novalidate;

Schemaspy does not display these FK's.

Discussion

  • John Currier

    John Currier - 2011-01-05

    Can you try the latest beta at http://schemaspy.sourceforge.net/schemaSpy.jar and let me know if that resolves it? Previously views weren't being fully evaluated for relationships.

    Thanks,
    John

     
  • Michael M

    Michael M - 2011-01-05

    Does indeed solve the problem. Thanks very much!

     

Log in to post a comment.