Alter Options - Teradata Vantage

You must specify at least one table option or one alter option for a basic ALTER TABLE request.

You can specify only table options, only alter options, or you can specify table and alter options. If you specify table and alter options, you must first specify table options and then alter options.

You cannot modify or revalidate a table or join index in the same ALTER TABLE request you run to modify basic table parameters.

• ADD column_name
• ADD COLUMN (column_name)
• ADD ROW (column_name)
• ADD SYSTEM (column_name )
• ADD (column_name ) AUTO COMPRESS
• ADD PERIOD FOR
• ADD CONSTRAINT name
• ADD row_level_security_constraint_name CONSTRAINT
• ADD FOREIGN KEY REFERENCES
• ADD CHECK (boolean_condition)
• ADD UNIQUE (column_name)
• ADD PRIMARY KEY (column_name)
• MODIFY CHECK (boolean_condition )
• RENAME
• DROP PERIOD FOR
• DROP column_name
• DROP CONSTRAINT name
• DROP row_level_security_constraint_name CONSTRAINT
• DROP FOREIGN KEY REFERENCES
• DROP CHECK
• DROP INCONSISTENT REFERENCES