16.10 - Adding a Security Constraint Column to a Table - Teradata Database

Teradata Database Security Administration

Teradata Database
Release Number
Release Date
June 2017
Content Type
Publication ID
English (United States)

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

ALTER TABLE  table_name  ADD  constraint_name  CONSTRAINT ;


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.