Archives of the TeradataForum

Message Posted: Fri, 09 Nov 2012 @ 14:21:59 GMT

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

     create table test1
     (single_quote char(1) compress ('27'xc)
     ) no primary index;

     show table test1;


     CREATE MULTISET TABLE test1 ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           single_quote CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS '''')
     NO PRIMARY INDEX ;

Kyle Prescott
DBA Manager
Unum-GHDS
Chattanooga, TN

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