VARCHAR Data Type with Primary Index Example

Teradata® Listener™ User Guide

brand
Analytical Ecosystem
prodname
Teradata Listener
vrm_release
2.05
category
User Guide
featnum
B035-2910-039K
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 );