RE: foreign key constraint and the index_name in user_constraint table

The index_name column of DBA_CONSTRAINTS was new with version 9 and only contains an entry when the constraint_type = 'P' for primary key or = 'U' for unique constraint. In other words this column shows you the index that supports a PK or UK constraint. See the Oracle 9.x or 10.x Reference Manaul for more information about DBA_CONSTRAINTS.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of nn20002_at_netscape.net Sent: Thursday, September 30, 2004 7:51 PM To: oracle-l_at_freelists.org
Subject: foreign key constraint and the index_name in user_constraint table

Hi,
Could you please help me in this issue.
I have a foreign key on a child table referencing the primary key of the parent table. I have created the index on the foreign key on the child table. Now, how do I know that the foreign key constraint is using the index or not.
I tried to see the index name from user_constarints table, but it always shows empty. When index_name is empty, what does it mean, even though I have it.
Thanks
nagu

--
http://www.freelists.org/webpage/oracle-l