| Subject: | Oracle check constraint failes to parse |
Hi,
First fantastic job. Unfortunately I have one component of my DDL that
I can't put through the converter.
Using a well formed Oracle table creation statement containing a CHECK
constraint exhibits the error below.
CREATE TABLE TEAM_CONTACT (
TEAM NUMBER(3) NOT NULL,
CONTACT_ORDER NUMBER(1) NOT NULL,
CONTACT_EMAIL VARCHAR2(5) NOT NULL,
IS_CURRENT NUMBER(1) DEFAULT 0 NOT NULL,
CONSTRAINT PK_TEAMCONT PRIMARY KEY(TEAM,CONTACT_ORDER),
CONSTRAINT UQ_TEAM_EMAIL UNIQUE(TEAM,CONTACT_EMAIL),
CONSTRAINT CHK_ORD CHECK(CONTACT_ORDER > 0)
);
ERROR (line 8): Invalid field: Was expecting data type but found
"CHK_ORD CHECK(CONTACT_ORDER > 0)," instead
Kind Regards,
Keiran M Raine