> 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
Posted by: "Leyne, Sean" <Sean@broadviewsoftware.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
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