Re: Update of CHECK constraints

On Wed, 10 Aug 2005 21:48:29 +0300, "Quixote" <yuya_at_isd.dp.ua> wrote:

>Please, advise me in what system table should I look for existing
>constraints
>for some table.
>Is exists some method to update check constraints or I should remove old
>with
>the same name and add the new one?
>
>
>Thank you.
>

select * from user_constraints
the column constraint_type denotes the type of constraint 'C' for check, 'P' for primary, 'R' for foreign key. The commands to deal with constraints are described in the SQL reference manual under 'Constraint Clause'

--
Sybrand Bakker, Senior Oracle DBA