为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:
【CPU】:
【问题描述】*:
CREATE TABLE PROPERTIES (
VALUE VARCHAR2(4000),
PROPERTY_DEFINITION_ID VARCHAR2(36) NOT NULL,
ITEM_ID VARCHAR2(36) NOT NULL,
WORKING_CONDITION_ID VARCHAR2(36) NOT NULL,
UNIT_ID VARCHAR2(36)
);
CREATE INDEX PROPERTIES_ITEM_ID ON PROPERTIES (ITEM_ID);
CREATE INDEX PROPERTIES_P_D_ID ON PROPERTIES (PROPERTY_DEFINITION_ID);
CREATE INDEX PROPERTIES_VALUE ON PROPERTIES (VALUE);
ALTER TABLE PROPERTIES ADD CONSTRAINT "fk_PROPERTIES_ITEMS_1" FOREIGN KEY (ITEM_ID) REFERENCES ITEMS(ID) ON DELETE CASCADE;
ALTER TABLE PROPERTIES ADD CONSTRAINT "fk_PROPERTIES_P_D_1" FOREIGN KEY (PROPERTY_DEFINITION_ID) REFERENCES PROPERTY_DEFINITIONS(ID) ON DELETE CASCADE;
ALTER TABLE PROPERTIES ADD CONSTRAINT "fk_PROPERTIES_UNIT_ID_1" FOREIGN KEY (UNIT_ID) REFERENCES UNITS(ID);
ALTER TABLE PROPERTIES ADD CONSTRAINT "fk_PROPERTIES_W_C_1" FOREIGN KEY (WORKING_CONDITION_ID) REFERENCES WORKING_CONDITIONS(ID) ON DELETE CASCADE;
这是建表相关语句 但是创建完发现索引重复了
应该是查询语句的问题,那几个查出来的系统索引,是由创建约束带出来的,实际上数据库是不允许同一列反复创建索引的。