在已存在的表结构上添加主键、外键、联合主键、联合索引的例子
-- 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)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14663377/viewspace-1035248/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14663377/viewspace-1035248/