ALTER TABLE DROP COLUMN - Amazon Athena
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

ALTER TABLE DROP COLUMN

Drops a column from an existing Iceberg table.

Synopsis

ALTER TABLE [db_name.]table_name DROP COLUMN col_name

Example

ALTER TABLE iceberg_table DROP COLUMN userid