.drop column

Removes a column from a table.

To drop multiple columns from a table, see drop table columns.

Note

This command does not physically delete the data, and does not reduce the cost of storage for data that was already ingested.

Warning

This command is irreversible. All data in the column that is removed will no longer by queryable. Future commands to add that column back will not be able to restore the data.

Syntax

.drop column TableName . ColumnName

drop table columns

Removes multiple columns from a table.

Note

This command does not physically delete the data, and does not reduce the cost of storage for data that was already ingested.

Warning

This command is irreversible. All data in the column that is removed will no longer by queryable. Future commands to add those columns back will not be able to restore the data.

Syntax

.drop table TableName columns ( Col1 [, Col2]... )