Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Nov 2008 @ 16:21:14 GMT

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

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

I think the problem is that your table has a TABLE level constraint NOT a column level constraint, but you are trying to modify a column level constraint.

If you want this to be a column level constraint you would have to use:

     ALTER TABLE manufacturing.employees
            ADD  deptno CHECK (deptno > 3)
            DROP CONSTRAINT employees_Check_deptno;

I don't think you can avoid using the constraint name in this case.

A column level constraint in the original table definition would look like:

     DeptNo SMALLINT CHECK (deptno > 10),

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