Archives of the TeradataForum

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

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

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>>