Greetings All,
Firebird v2.5.4
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?
Mike
Posted by: "stwizard" <stwizard@att.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment