Home » RDBMS Server » Server Administration » To get primary and corresponding foreign key
To get primary and corresponding foreign key [message #371991] Tue, 02 January 2001 01:07 Go to next message
Satya
Messages: 36
Registered: January 2001
Member
How do we get to know the primary keys and the corresponding foreign keys from all the tables

Report message to a moderator

Re: To get primary and corresponding foreign key [message #371994 is a reply to message #371991] Tue, 02 January 2001 05:16 Go to previous messageGo to next message
Srinivasulu P
Messages: 5
Registered: December 2000
Junior Member
Check The Synanym User_constraints

Report message to a moderator

Re: To get primary and corresponding foreign key [message #372077 is a reply to message #371991] Tue, 09 January 2001 07:04 Go to previous message
Sandeep Udupa
Messages: 9
Registered: January 2001
Junior Member
In order to get which FOREGIN KEY is REFERENCING which PRIMARY KEY, you have take look into USER_CONSTRAINTS table.

SELECT * FROM user_constraints
WHERE constraint_name = 'NAME OF THE CONSTRAINT IN CAPITAL LETTERS';

Hope this answers your query.

Report message to a moderator

Previous Topic: Trigger question
Next Topic: Decimal format in SqlLoder
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 02:08:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.