Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 10 Nov 2008 @ 15:05:02 GMT


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


Subj:   Re: Error while modifying constraint
 
From:   Dempsey, Mike

You do not have a choice to alter this constraint using the column name because it is NOT a column level constraint. The only way to change it is to use the constraint name.

If your standards say you must not use the constraint names then you need to define your tables with column level constraints in future. (Not table level constraints as your current definition uses)

Eg.

     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 CHECK ( deptno > 10 )
           )
     PRIMARY INDEX ( EmpNo )
     INDEX ( Name );

Note that there is NO COMMA after the word SMALLINT. (That is what makes it a column level constraint)


Mike Dempsey
Teradata Client Tools



     
  <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: 28 Jun 2020