Adding a Security Constraint Column to a Table - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

You can use the ALTER TABLE statement to add a security constraint column, for example:

ALTER TABLE  table_name  ADD  constraint_name  CONSTRAINT ;

where:

Syntax Element Description
constraint_name Specifies an existing CONSTRAINT object name.
  • The name must be unique in the table.
  • A maximum of 5 security constraint columns are allowed in a table.
  • The name becomes a constraint column name. The data type for the column is the data type for the corresponding CONSTRAINT object.
  • When adding a security constraint column to a populated table, each row uses the session label for the new constraint column value.
You cannot add a security constraint column to a table with a hash index or join index.
CONSTRAINT The CONSTRAINT keyword identifies the constraint_name as an existing constraint object.