Archives of the TeradataForum
Message Posted: Mon, 10 Nov 2008 @ 15:05:02 GMT
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)
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|