Archives of the TeradataForum

Message Posted: Mon, 10 Nov 2008 @ 15:05:02 GMT

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

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)

Eg.

     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)

Mike Dempsey
Teradata Client Tools

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