Articles in this section

column rename

Sara Levy
  • Updated
Follow

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

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

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

Related articles

Comments

0 comments

Article is closed for comments.