Primary Key

[Despina]

hi!
I am new at Oracle and i need some tips for finding the primary an foreign keys of the data base tables.
Thank u!

[amitpatel66]

hi!
I am new at Oracle and i need some tips for finding the primary an foreign keys of the data base tables.
Thank u!

SELECT * FROM ALL_CONSTRAINTS WHERE TABLE_NAME = '<Your table name here>'
 

[amitpatel66]

SELECT * FROM ALL_CONSTRAINTS WHERE TABLE_NAME = '<Your table name here>'
 

Check out below Query as well:

SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = '<Your table name here>'
 

[Despina]

Check out below Query as well:

SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = '<Your table name here>'
 

THANK U!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
IS THIS ALSO WORKING
SELECT TABLE_NAME, CONSTRAINT_TYPE, CONSTRAINT_NAME FROM USER_CONSTRAINTS
WHERE TABLE_NAME = 'ADASDASAS'

[Despina]

Thank U! I Ll Learn The Rules