Disable constraint at B.Dados Oracle !!

[Carlos Sérgio]

Personal,

Good afternoon,

How do I disable a constraint of a particular table, through SQL commands, in Oracle, please?

obligate ...

Carlos

[dr_gori]

You can achieve with Alter Table. See:

Select all

alter table SUA_TABELA disable constraint SUA_CONSTRAINT; 

The same to enable:

Select all

alter table SUA_TABELA enable constraint SUA_CONSTRAINT; 

[Carlos Sérgio]

Thanks! Thanks!