Archives of the TeradataForum

Message Posted: Mon, 10 Nov 2008 @ 10:39:48 GMT

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

Hi Neha,

I think Mike has it right, you need to remove the table level restraint and redefine it as a column level restraint.

Using the alter table statements Mike provided you will change your table from this:

     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,
              CONSTRAINT employees_Check_deptno CHECK ( deptno >  10  ))
        PRIMARY INDEX ( EmpNo )
        INDEX ( Name );

To be this:

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

That puts the constraint at column level so to can modify it using alter table to your hearts content.

Hope this helps

Jeff

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