VARCHAR Data Type Examples - Teradata VantageCloud Lake

Example: VARCHAR Data Type

The following statement creates a table that defines two VARCHAR columns: InfoKey and InfoData.

CREATE TABLE InfoTable
  (InfoKey VARCHAR(10) NOT NULL
  ,InfoData VARCHAR(16384) )
UNIQUE PRIMARY INDEX ( InfoKey );

The following statements insert character data of varying lengths into the InfoKey and InfoData columns:

INSERT INTO InfoTable ('001_5_799', 'Data for key 001_5_799');
INSERT INTO InfoTable ('2', 'Data for key 2');

Example: LONG VARCHAR Data Type

The following statement creates a table that defines a LONG VARCHAR column called InfoData.

CREATE TABLE InfoTable (InfoData LONG VARCHAR);