column delete

Prev Next

This command deletes one or more columns from a VAST database table.

Usage

column delete --table-name TABLE
              --schema-name SCHEMA
              --arrow-schema COLUMNS_TO_DELETE
              --database-name DATABASE 

Required Parameters

--table-name TABLE

Enter the name of the table that contains the column or columns to be deleted.

--schema-name SCHEMA

Enter the name of the schema where the table resides.

--arrow-schema COLUMNS

Enter a comma-separated list of columns to be deleted.

The columns are specified using the Arrow format, for example:

col1-int8,col2-string,col3-int8

Note

Complex data types are not supported on this command. To delete a column with a complex data type, use VAST Web UI.

--database-name DATABASE

Enter the name of the database where the table resides.

Example

This example shows deleting the column age from the table named cats :

vcli: admin> column delete --table-name cats --schema-name schema1 --arrow-schema age-int8 --database_name vastdb