ANSI Compliance - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

INSERT is ANSI SQL:2011-compliant with extensions.

The INS abbreviation is a Teradata extension to the ANSI SQL:2011 standard.

Note that in the ANSI SQL:2011 definition, this statement is named INSERT INTO, while in the Teradata definition, INTO is an optional keyword.

The following privilege rules apply to the INSERT statement:

  • You must have the INSERT privilege on the referenced table or column set.
  • To insert rows into a table through a view, you must have the INSERT privilege on the view. Also, the immediate owner of the view must have the INSERT privilege on the underlying view, base table, or column set. The immediate owner of the view is the database in which the view resides.
  • To insert rows into a table using a query specification, you must have the SELECT privilege for the referenced tables or views.
  • When you perform an INSERT with a WHERE clause predicate that requires READ access to an object, you must have the SELECT privilege on the accessed object.
  • The privileges required for an INSERT … SELECT … LOGGING ERRORS operation are the same as those for INSERT … SELECT operations without a LOGGING ERRORS option except that you must also have the INSERT privilege on the error table associated with the target data table for the INSERT … SELECT operation.