ALTER TABLE Syntax Elements (Basic) - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
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.