.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]... )