Archives of the TeradataForum

Message Posted: Fri, 07 Nov 2008 @ 10:40:39 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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?

Regards,

Neha

	<Prev	Next>		<<First	<Prev	Next>	Last>>