Re: constraints and foreign keys

maevans wrote:
>
> I've got several referencial constraints attached to tables. How do I
> get the table name and column name of the the constraint for a particular
> table? I'm sure its simple but it eludes me...

Try querying the user_constraints view. I'll thinkg you'll find what you are looking for.

Tim

-- 
+-----------------------------------------------------------------------+ 
|Timothy E. Taylor				Oracle Government       | 
|Staff Sales Consultant				3 Bethesda Metro Center | 
|Internet:	ttaylor_at_us.oracle.com		Suite 1400              | 
|Office:	301-907-2395			Bethesda, MD 20814      | 
|Fax:		301-657-0037                                            | 
+-----------------------------------------------------------------------+ 
| 	They teach you to fix what needs to be broke (P.W., 1993)	| 
+-----------------------------------------------------------------------+