Duplicate Rows - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
wxs1608578396899.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

ANSI session mode allows rows, but duplicate rows are possible only if the table does not contain a primary key or any columns with unique constraints. Otherwise, a "duplicate row" error will be generated.

In Teradata session mode, duplicate rows generated from an INSERT ... SELECT statement were ignored and no error or warning was generated.