| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Update of CHECK constraints
Quixote 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.
you can use the user_constraints and user_cons_columns VIEWs to see them.
Use the ALTER TABLE command to modify them.
Ed Received on Wed Aug 10 2005 - 15:00:29 CDT
 |
 |