create index

最新推荐文章于 2024-06-16 18:45:11 发布

原创最新推荐文章于 2024-06-16 18:45:11 发布 · 644 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#table #date

1.
CREATE UNIQUE INDEX FBL_PICKUP_SHIPPING_HOL_PK ON FBL_PICKUP_SHIPPING_HOLIDAYS (STORE_ID, STORE_LOCAL_ID, HOLIDAY_DATE, ASSET_VERSION);
ALTER TABLE FBL_PICKUP_SHIPPING_HOLIDAYS ADD CONSTRAINT FBL_PICKUP_SHIPPING_HOL_PK PRIMARY KEY (STORE_ID, STORE_LOCAL_ID, HOLIDAY_DATE, ASSET_VERSION)USING INDEX;

ALTER TABLE FBL_PICKUP_SHIPPING_HOLIDAYS DROP CONSTRAINT FBL_PICKUP_SHIPPING_HOL_PK;
DROP INDEX FBL_PICKUP_SHIPPING_HOL_PK;

2.
ALTER TABLE FBL_PICKUP_SHIPPING_HOLIDAYS ADD CONSTRAINT FBL_PICKUP_SHIPPING_HOL_PK PRIMARY KEY (STORE_ID, STORE_LOCAL_ID, HOLIDAY_DATE, ASSET_VERSION);
ALTER TABLE FBL_PICKUP_SHIPPING_HOLIDAYS DROP PRIMARY KEY;

3.EVERY STATUS
ALTER TABLE FBL_PICKUP_SHIPPING_HOLIDAYS DROP CONSTRAINT FBL_PICKUP_SHIPPING_HOL_PK CASCADE DROP INDEX;