ALTER TABLE Syntax Elements (Basic) - Teradata Vantage

database_name

Containing database. The default is the database for the current session.

user_name

Containing user name. The default is the database for the current user.

table_name

Name of the table to be altered. This can be a base data table or a user-defined join index, but cannot be any of the following:

• Error table
• Volatile table
• System-defined join index

Also see ALTER TABLE Basic Options.