Archives of the TeradataForum
Message Posted: Mon, 10 Nov 2008 @ 08:08:03 GMT
The thing is that even if I use dbname.table name its not working. And Mike below is the table definition,
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 );
So I guess it is column level only. In the Teradata V2R5 SQL reference manual, for ALTER TABLE.. MODIFY (for modifyin constraints) two ways are mentioned
1) Through CONSTRAINT NAME - which works perfectly.
2) Through COLUMN NAME - Which causes the problem.
According to my project requirements I m not supposed to use the first method. So still getting the same error :(
Can you think of anything else, anything wrong that I may be doing?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|