Duplicate Rows - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.