VARCHAR Data Type with Primary Index Example - Teradata Listener

Teradata® Listener™ User Guide

Product
Teradata Listener
Release Number
2.03
Published
September 2018
Language
English (United States)
Last Update
2018-10-01
dita:mapPath
kum1525897006440.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2910
lifecycle
previous
Product Category
Analytical Ecosystem
CREATE MULTISET TABLE listener.testing_varchar ,NO FALLBACK
,
	NO BEFORE JOURNAL,
	NO AFTER JOURNAL,
	CHECKSUM = DEFAULT,
	DEFAULT MERGEBLOCKRATIO
	(
	 uuid VARCHAR (55) CHARACTER SET LATIN CASESPECIFIC,
	 source_id VARCHAR (55) CHARACTER SET LATIN)
CASESPECIFIC,
	 time_stamp TIMESTAMP (6) WITH TIME ZONE,
	 data VARCHAR (512) CHARACTER SET LATIN)
PRIMARY INDEX ( uuid );