Home Page for the TeradataForum
 

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023