Home » RDBMS Server » Server Administration » Re: How to find out forein keys
Re: How to find out forein keys [message #373978] Fri, 18 May 2001 05:37
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
Member
Hai,
Check the following sql.

select constraint_name,constraint_type,table_name,r_owner,r_constraint_name
from user_constraints where constraint_type = 'R'

Regards,
Giridhar Kodakalla

Report message to a moderator

Previous Topic: Very Interesting Question
Next Topic: Password for user SYS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 16:43:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.