Inserting Rows through Views - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

Use caution when granting the privilege to insert data through a view because data in fields not visible to the user might be inserted when a row is inserted through a view.

The following rules apply to inserting rows through a view:
  • Both you and the immediate owner of the view must have the appropriate privileges.
  • The view must reference columns in only one table or view.
  • None of the columns in the view can be derived by using an expression to change values in the underlying table.
  • Each column in the view must correspond one to one with a column in the underlying table or view.
  • The view must include any column in the underlying table or view that is declared as NOT NULL.
  • No two view columns can reference the same column in the underlying table.
  • If the request used to define a view contains a WHERE clause, and WITH CHECK OPTION, all values inserted through that view must satisfy constraints specified in the WHERE clause.

    If a view includes a WHERE clause but does not include the WITH CHECK OPTION, then data can be inserted that is not visible through that view.