Archives of the TeradataForum

Message Posted: Fri, 07 Nov 2008 @ 11:07:13 GMT

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

Please change your query to and look at the note below :-

     ALTER TABLE MANUFACTURING.employees
     MODIFY CONSTRAINT employees_Check_deptno CHECK (deptno >3)

Note: Only constraint that can be modified is a named CHECK constraint.

Regards,

Rishi.

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