Duplicate Rows

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

ANSI allows duplicate rows. Duplicate rows are possible only if the table does not contain a primary key or any columns with unique constraints. In previous releases of Teradata, duplicate rows generated from an INSERT ... SELECT statement were ignored and no error or warning was generated. If a table permits duplicate rows, the duplicate rows are inserted and an error is generated.