Teradata - Table Type Specifications of Set VS Multiset

There are two different type tables in Teradata. They are SET and MULTISET. If we do not specify the table type when we creating a table in Teradata, SET is used as the default.

• SET table - does not allow duplicate rows and Teradata will check to ensure that no two rows in a table is exactly the same
• MULTISET table - allow duplicate rows