Teradata create table syntax with examples

We can create SET/MULTISET tables in Teradata. There are few differences between SET and MULTISET tables.Let’s discuss about syntax to create these tables.

Create Table Syntax:

We have to specify the table type,table options,column definitions and Index definitions in the create table statement of Teradata.

Create SET table example

The Teradata SET table did not allow duplicate values in table.In SET table,we need to specify the Unique primary index in the index definition area which helps teradata to avoid the duplicate values.

Create MULTISET table example

MULTISET tables allow duplicate values in the table.We can create the MULTISET table without specifying the Index definitions such Primary Index or Unique Primary Index.
By default,it allow the duplicate values if we not specifying index definitions.