tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER TABLEALTER TABLE DROP COLUMN

ALTER TABLE DROP COLUMN

Download
Focus Mode
Font Size
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 table
column_name: Name of the column to be deleted

Example

ALTER TABLE `TBL` DROP COLUMN `COL2`



Previous Topic: ALTER TABLE ADD COLUMN AFTER/FIRSTNext Topic: ALTER TABLE ADD PARTATION

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback