Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Data Dictionary Views
Oracle Data Dictionary Views [message #2952] Sun, 25 August 2002 07:00 Go to next message
keane
Messages: 23
Registered: June 2002
Junior Member
hi, how can i get the information about the referencial integrity from the Data Dictionary Views?
if i create the following two tables, how too know the table t2 is referencing t1?
create t1
(a varchar2,
primary a
);
create t2
(b varchar2,
c varchar2,
foreign key (c) references a
);

thanks a lot.
keane
Re: Oracle Data Dictionary Views [message #2953 is a reply to message #2952] Sun, 25 August 2002 08:06 Go to previous messageGo to next message
Robert Kuhlmann
Messages: 35
Registered: March 2002
Member
Hey Keane
lok at user_constraints in the columns
R_CONSTRAINT_NAME and constraint_name.
thanks, Robert [message #2954 is a reply to message #2952] Sun, 25 August 2002 08:41 Go to previous message
keane
Messages: 23
Registered: June 2002
Junior Member
OK, got it. thanks a lot.
Previous Topic: UTL_FILE
Next Topic: Execute statements after every 'Enter'
Goto Forum:
  


Current Time: Thu Apr 25 02:16:09 CDT 2024