terminology q. regarding FK
- From: mh@xxxxxxxxx
- Date: Mon, 03 Nov 2008 03:50:10 GMT
I'm doing some FK analysis of our tables by making a directed
graph representing FK dependencies and then traversing the
graph. In my code, I name everything using directed graph
terminology, but I'd like to have something a bit more
"user friendly" in the report.
In this scenario:
create table t1(a varchar2(20));
alter table t1 add constraint t1_fk foreign key(a) references t2(b);
t1.a must exist in t2.b. So,
t1 is the _______ of t2.
t2 is the _______ of t1.
Many TIA!
Mark
--
Mark Harrison
Pixar Animation Studios
.
- Follow-Ups:
- Re: terminology q. regarding FK
- From: Frank van Bortel
- Re: terminology q. regarding FK
- From: Carlos
- Re: terminology q. regarding FK
- Prev by Date: Re: What's a quick simple way to test Oracle connectivity between client and database server?
- Next by Date: Re: What's a quick simple way to test Oracle connectivity between client and database server?
- Previous by thread: Re: using EXECUTE IMMEDIATE to run DBMS_STATS.GATHER_SCHEMA_STATS
- Next by thread: Re: terminology q. regarding FK
- Index(es):
Relevant Pages
|
Loading