Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Error while modifying constraint
 
From:   Shukla, Neha

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016