I have a request from a developer to determine if a column is computed,
has a primary key
has a foreign key.
Im looking through the dictionary tables eg user_tab_columns but these
firlds seem to be elusive.
Any ideas what views to querry ?
Many thanks
bob
--
Please see the official ORACLE-L
Take a look at dba_cons_columns for primary and foreign key constraints
Jay Miller
-Original Message-
Sent: Friday, November 15, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
I have a request from a developer to determine if a column is computed,
has a primary key
has a
Bob,
Take a look at tables like user_constraints and user_cons_columns - the
constraint_type column would
definitely tell you whether it is a primary or foreign key, I am not sure
about computed.
HTH
Sumathy
-Original Message-
Sent: Friday, November 15, 2002 11:59 AM
To: Multiple
Look at DBA_CONS_COLUMNS
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 15, 2002 11:59 AM
I have a request from a developer to determine if a column is computed,
has a primary key
has a
Look at DBA_CONS_COLUMNS
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
I see, thank you
select uc.constraint_type, uc.constraint_name, ucc.column_name,
uc.search_condition
from user_constraints uc, user_cons_columns ucc
where uc.owner = 'BOB' and
uc.constraint_name
This is what I ended up doing...
select decode(constraint_type,
'C', 'Check Constraint',
'P', 'Primary Key',
'R', 'Foreign Key',
'U', 'Unique ',
'V', 'With Check Option for view',
'undefined')
constraint_name, column_name,