Yang, Tong 48706b7552 MRS COMP-LTS 320-lts.1 version

Reviewed-by: Kacur, Michal <michal.kacur@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2024-04-12 12:51:10 +00:00

3.6 KiB

Raw Permalink Blame History

Deleting a 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.

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 Adding a Column.

Response

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

Parent topic: SparkSQL Schema Evolution and Syntax Description

3.6 KiB Raw Permalink Blame History