执行下列语句后:
create table abc(
bh integer,
name char(20)
)
alter table abc add check ( bh between 1 and 1000)
alter table abc add check ( bh between 1 and 100 )
alter table abc add check ( bh between 1 and 500 )
数据库里保存了下面三条语句:
alter table abc add check ( bh between 1 and 1000)
alter table abc add check ( bh between 1 and 100 )
alter table abc add check ( bh between 1 and 500 )
真正起作用的还是第二条语句.
我如何删除第一条和第三条语句.
---------------------------------------------------------------
alter table job drop CONSTRAINT 【check 名】