By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,939 Members | 1,541 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,939 IT Pros & Developers. It's quick & easy.

Query to Get Primary and Foreing Key.

P: 2
Hello .I need query in Oracle to get Foreing key and Primary key

For Example
I have two tables

Category_Product
Id_Category PK
Description

Product
IdProduct PK
Id_Category FK
Description

I need to get this

Table ..................Column.............. TipyConstraint.........Colum Ref Table _Ref

Category_product......... ..Id_Category .................PK
Product......................... Id_Producto.............. PK
Product .........................Id_Category ............... FK ...... Id_Category...... Category_Product
Feb 20 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.