select * from user_cons_columns
where constraint_name=(select constraint_name
from user_constraints where table_name = '1' and constraint_type='P');
.. Bunyamin ..
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 10,
you can select from user_cons_columns to find columns.
lucy
On Thu, 10 May 2001, Helmut Daiminger wrote:
Hi!
Is there a data dictionary view that gives me all the columns in a primary
key of a table?
I can query user_constraints to find out about all constraints on a table:
select *
user_cons_columns
-Original Message-
Sent: Thursday, May 10, 2001 1:23 PM
To: Multiple recipients of list ORACLE-L
Hi!
Is there a data dictionary view that gives me all the columns in a primary
key of a table?
I can query user_constraints to find out about all constraints on a table:
Helmut
ALL_CONS_COLUMNS contains columns and position for each constraint.
Similarly ALL_IND_COLUMNS contains columns for each index.
If you need to find the columns through SQL, use the views or join to them. If
you don't need the SQL, get a tool like TOAD (free version,
Title: RE: What columns are in the Primary Key
-Original Message-
From: Helmut Daiminger [mailto:[EMAIL PROTECTED]]
Is there a data dictionary view that gives me all the columns
in a primary
key of a table?
Try user_cons_columns.
It would probably be of interest to you
Could also try
select * from user_ind_columns where index_name = 'PK_ACCOUNTS'
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 10 May 2001 19:16
To: Multiple recipients of list ORACLE-L
use user_cons_columns:
SQL desc user_cons_columns
NameNull?