Archives of the TeradataForum

Message Posted: Tue, 10 Oct 2006 @ 21:14:17 GMT


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

Subj:		Index columns reversed in SHOW TABLE

From:		Anomy Anom

<-- Anonymously Posted: Tuesday, October 10, 2006 17:06 -->

I created a table using the following ddl. If I do a show table (shown in the second create below), the order of the column in the index is reversed. Has anyone ever seen this before?

Thanks

     CREATE MULTISET TABLE sandboxa.tmp1 ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           mfr_no CHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           item_no CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           country_code CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           product_code_1 CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           product_code_2 CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           product_code_3 CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           product_code CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)
     PRIMARY INDEX ( mfr_no ,country_code );


     CREATE MULTISET TABLE sandboxa.tmp1 ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           mfr_no CHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           item_no CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           country_code CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           product_code_1 CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           product_code_2 CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           product_code_3 CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           product_code CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)
     PRIMARY INDEX ( country_code, mfr_no );


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

Attachments

Library

Quick Reference