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

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.