alter table yourtable ADD CONSTRAINT cc_check CHECK (cc > 0 and cc < 13)
增加约束限制,如: CREATE table tableName( ID char(10) NOT NULL CONSTRAINT ID_chk CHECK(ID LIKE '[A-Z][1-2][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'), MemberNo smallint not null CONSTRAINT MemberNo_chk CHECK(MemberNo BETWEEN 0 AND 13), name varchar(20) NOT NULL, address varchar(60) NOT NULL )
对某字段增加约束限制: EXEC sp_bindrule ID_chk, 'tableName.ID'取消约束限制: EXEC sp_unbindrule ID
ADD CONSTRAINT cc_check CHECK (cc > 0 and cc < 13)
CREATE table tableName(
ID char(10) NOT NULL
CONSTRAINT ID_chk
CHECK(ID LIKE '[A-Z][1-2][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
MemberNo smallint not null
CONSTRAINT MemberNo_chk
CHECK(MemberNo BETWEEN 0 AND 13),
name varchar(20) NOT NULL,
address varchar(60) NOT NULL
)
EXEC sp_bindrule ID_chk, 'tableName.ID'取消约束限制:
EXEC sp_unbindrule ID