column delete

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 
             [--tenant-id TENANT]

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.Managing Table Columns
`--database-name DATABASE`	Enter the name of the database where the table resides.

Options

--tenant-id TENANT

Enter the ID of the tenant where the database resides.

If omitted, the default tenant is assumed.

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