Archives of the TeradataForum
Message Posted: Fri, 07 Nov 2008 @ 10:40:39 GMT
I m trying to modify constraint on a column. For this I'm not suppose to use the CONSTRAINT NAME, so I m doing through the column name it self but I'm getting an error.
CREATE SET TABLE MANUFACTURING.employees ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( EmpNo SMALLINT NOT NULL, Name VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC, DeptNo SMALLINT, CONSTRAINT employees_Check_deptno CHECK ( deptno > 10 )) /* Already existing constraint */ PRIMARY INDEX ( EmpNo ) INDEX ( Name );
I am using the below for modifying the constraint:
ALTER TABLE manufacturing.employees MODIFY deptno CHECK (deptno >3);
But I'm getting below error:
3913: Specified Check does not exist.
Can any one please tell me why am I getting this error?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|