MULTISET allows duplicates
SET does not.
This feature is supported in Teradata, which originally required rows in a
table to be unique, and later added the
MULTISET keyword to
CREATE TABLE command to allow the duplicate rows.
In other databases and in the SQL standard,
MULTISET is the only
supported option, so there is no explicit syntax.
Enum Constant Details
UNSPECIFIEDpublic static final TableCollectionType UNSPECIFIEDTable collection type is not specified.
MULTISETin ANSI mode, and
SETin Teradata mode.
SETpublic static final TableCollectionType SETDuplicate rows are not permitted.
MULTISETpublic static final TableCollectionType MULTISETDuplicate rows are permitted, in compliance with the ANSI SQL:2011 standard.
valuespublic static TableCollectionType values()Returns an array containing the constants of this enum type, in the order they are declared.
- an array containing the constants of this enum type, in the order they are declared
valueOfReturns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)