Archives of the TeradataForum

Message Posted: Fri, 30 Jan 2004 @ 14:09:45 GMT

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

Hi Mike,

Your question is interesting.

Here is what I believe.

1. CONSTRAINT is w.r.t to a table and not column, although you specify it at column level but at a broader sense a named constraint belongs to the table as a whole.

2. Un-named constriant is w.r.t a column.

You may check it bay the show table command too.

Although I created the table with the syntax you provided. Here is what the show table says and you could easily guess that constraints are treated at table level.

CREATE SET TABLE columnconst ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      c29b CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC CHECK ( (c29b = 'y') OR (c29b =  'n') ) NOT NULL,
      c29a CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL COMPRESS 'Y',
      c29c CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL COMPRESS 'x',
      CONSTRAINT MYCONST3 CHECK ( (c29c =  'y') OR  (c29c =  'n') ),
      CONSTRAINT MYCONST2 CHECK ( (c29a =  'y') OR  (c29a =  'n') )) PRIMARY INDEX ( c29b );

Here I would like to double you & treat this as a bug.

Thanks, Vivek.

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