ALTER TABLE DROP COLUMN - Amazon Athena
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

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