ALTER TABLE DROP COLUMN
Last updated: 2024-08-07 17:15:45
Description
Supported engines: Presto and SparkSQL
Applicable table: Native Iceberg tables and external tables
Purpose: Delete a field from a data table.
Standard Statement
ALTER TABLE table_name DROP COLUMN column_name
Parameter
table_name: Name of the target tablecolumn_name: Name of the column to be deletedExample
ALTER TABLE `TBL` DROP COLUMN `COL2`
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback