在已存在的表结构上添加主键、外键、联合主键、联合索引的例子

-- Add Primary key
alter table TB_KERNEL_VERSION
add primary key (KVID)

-- Add Foreign key
alter table TB_KERNEL_VERSION
add constraint FK_TB_KERNEL_VERSION_RESOLU foreign key (RESOLUTIONID)
references TB_RESOLUTION (ID);

-- Add Union Primary key
alter table T_SYSTEM_ROLEFUNC
add constraint PK_ROLEID_FUNCID primary key (ROLEID, FUNCID)

-- Create/Recreate Union indexes
create index IDX_SHV_KV on TB_KERNEL_VERSION (SHV, KV)

[@more@]

ITPub博客

在已存在的表结构上添加主键、外键、联合主键、联合索引的例子