> Trying to create a simple table and receive this error: > > unsuccessful metadata update > cannot create index PK_CUR_CASE_INV_NON_JUD_CNT > while executing: > ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT > FK_CUR_CASE_INV_RPT3 > FOREIGN KEY (REPORT_ID) REFERENCES CUR_CASE_INV_RPT > (REPORT_ID) > ON DELETE CASCADE > ON UPDATE NO ACTION > > > Here is the DDL: > > CREATE TABLE CUR_CASE_INV_NON_JUD_CNTY > ( > REPORT_ID INTEGER NOT NULL, > FILING_COUNTY VARCHAR( 54) NOT NULL COLLATE NONE, > NON_JUD_COUNT INTEGER NOT NULL, > NON_JUD_AMT NUMERIC( 15, 2) NOT NULL, > CONSTRAINT PK_CUR_CASE_INV_NON_JUD_CNT PRIMARY KEY > (REPORT_ID, FILING_COUNTY) > ); > COMMENT ON TABLE CUR_CASE_INV_NON_JUD_CNTY IS '07.19.16 Stores > the filing counties and non judgment data for use with the current case > inventory stats report.'; > ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT > FK_CUR_CASE_INV_RPT3 > FOREIGN KEY (REPORT_ID) REFERENCES CUR_CASE_INV_RPT > (REPORT_ID) > ON DELETE CASCADE > ON UPDATE NO ACTION > ; > > Any ideas?
What tool are you using to execute the DDL? Sean
