column rename

This command renames a table column.

Usage

column rename --name OLD_COLUMN_NAME
              --owner-name OWNER
              --table-name TABLE
              --schema-name SCHEMA
              --database-name DATABASE 
              --new-column-name NEW_COLUMN_NAME
             [--tenant-id TENANT]

Required Parameters

`--name OLD_COLUMN_NAME`	Enter the name of the column to be renamed. If the column to be renamed is a nested column, use the dotted format `a.b.c` to specify the parent column(s) (`a`, `b`) and the nested column (`c`).
`--owner-name OWNER`	Enter the user name of the VAST database owner.
`--table-name TABLE`	Enter the name of the table that contains the column.
`--schema-name SCHEMA`	Enter the name of the schema where the table resides.
`--database-name DATABASE`	Enter the name of the database where the table resides.
`--new-column-name`	Enter a new name for the column. The name must meet the requirements for S3 object names.

Options

--tenant-id TENANT

Enter the ID of the tenant where the database resides

If omitted, the default tenant is assumed.

Example

The following example shows renaming a column named abc into xyz:

vcli: admin> column rename --name abc --owner-name ed --table-name customer --schema-name schema1 --database-name vastdb --new-column-name xyz