在已存在的表結構上新增主鍵、外來鍵、聯合主鍵、聯合索引的例子

在已存在的表結構上新增主鍵、外來鍵、聯合主鍵、聯合索引的例子

-- 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@]