Archives of the TeradataForum
Message Posted: Fri, 07 Nov 2008 @ 16:21:14 GMT
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),
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|