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
Required Parameters
| Enter the name of the column to be renamed. If the column to be renamed is a nested column, use the dotted format |
| Enter the user name of the VAST database owner. |
| Enter the name of the table that contains the column. |
| Enter the name of the schema where the table resides. |
| Enter the name of the database where the table resides. |
| Enter a new name for the column. The name must meet the requirements for S3 object names. |
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