新手问：怎么修改约束条件？

[sunfirey]

以建一表，中有以下字段，如何用SQL语句把后面的15改为30
SOLD NUMBER(2) CHECK(SOLD BETWEEN 15 AND 15)

[sunfirey]

各位好兄帮一下忙呀，成功了就结帖~~~~~~~~~`

[jiezhi]

alter table a sold number(2) check(sold between 15 and 30)

[jiezhi]

alter table a modify (sold number(2) check(sold between 15 and 30))

[black_snail]

do it first
ALTER TABLE a DROP CONSTRAINT <your contraints name>
how to find your contraint name , please
refer to

select CONSTRAINT_NAME
from user_cons_columns where table_name = MMMM
and column_name = MMMM

[sunfirey]

ORA-02253: 此处不允许约束条件说明　　　是怎么回事呀？

[more_zou]

select constraint_name from user_constraints where table_name='yourtab' and constraint_type='C';
假设查出来的constraint_name为sys_c00100；
然后
alter table drop constraint sys_c00100;
然后
alter table add constraint ck_sold check(sold between 1 and 20);

[more_zou]

不好意思，应该是
alter table yourtablename drop...
alter table yourtablename add ...

[sunfirey]

OK，问题解决，结帖~~~~~~~