show PK,FK

[netagent4]

I created a table with multiple and primary keys. How can i view my primary and foreign keys in a description of a table..?

[bensr]

View here:
select * from sys.all_constraints
where ...

[rotem_fo]

Hi,
if by description you mean to use the describe command, then you can't.

you can use this query:
-----------------------------------------------
accept tab_name prompt "Enter Table Name: "
select table_name, constraint_name, constraint_type
from user_constraints
where constraint_type in ('P','R')
where table_name = '&tab_name';
-----------------------------------------------

If you want to know the columns involved in any constraint
simply query the user_cons_columns:
-----------------------------------------------
select constraint_name,column_name from user_cons_columns
where constraint_name = 'constraint_name'
order by constraint_name,column_name,position;
-----------------------------------------------

Cheers,
R.