A alter table course add constraint ck_cno check ( property in ('考试','考查'))
B alter table course drop constraint ck_cno
C alter table course add check ( property in ('考试','考查'))
D alter table course add constraint ck_cno check property in ('考试','考查')