id int ,name varchar(12) constraint nn_name not null
id int ,name varchar(12) ,constraint ui_name unique(id)
id int primary key,name varchar(12);
id int,name varchar(12),primary key(id,name)
id int constraint fk_me references table(column)
id int ,name varchar(12),check (id between 10 and 100);
修改约束名:
alter table table_name rename constraint constraint_name to new_name
增加约束
alter table table_name modify column not null
alter table table_name add constraint constraint_name unique(column)
alter table table_name add primary key(column)
alter table table_name add column_name column_type references table(column)
alter table table_name add check();
删除约束
alter table table_name drop constraint constraint_name | primary key [cascade]
禁止约束
alter table table_name disable constraint constraint_name
激活约束
alter table table_name enable constraint constraint_name