1. 创建:
create table table_name
( col1_name int not null unique,
col2_name varchar2(10),
...
coln_name varchar2(10)
);
create table table_name
( col1_name int not null,
col2_name varchar2(10),
...
coln_name varchar2(10)
constraint uniquekey_name unique (col1_name,col2_name)
);
2. 修改:
alter table table_name
add unique (col1_name);
alter table table_name
add constraint uniquekey_name unique (col1_name,col2_name);
3. 删除:
alter table table_name
drop constraint uniquekey_name;