Updated on 2025-01-09 GMT+08:00

DROP COLUMN

Function

The ALTER TABLE ... DROP COLUMN command is used to delete a column.

Syntax

ALTER TABLE tableName DROP COLUMN|COLUMNS cols

Parameter Description

Table 1 DROP COLUMN parameters

Parameter

Description

tableName

Table name.

cols

Columns to be deleted. You can specify multiple columns.

Required Permissions

  • SQL permissions
Table 2 Permissions required for executing ALTER TABLE

Permission Description

ALTER permission on a table

  • Fine-grained permission: dli:table:alter
  • Metadata services provided by LakeFormation. Refer to the LakeFormation documentation for details on permission configuration.

Example

ALTER TABLE table1 DROP COLUMN a.b.c
ALTER TABLE table1 DROP COLUMNS a.b.c, x, y

a.b.c indicates the full path of a nested column. For details about the nested column rules, see ADD COLUMNS.

Response

You can run the DESCRIBE command to check which column is deleted.