rename_column

Renames a column in a table.

Available in a network database and requires the star$define role.

Parameters:

Name Optional Type Description
table$ Mandatory Text Table to rename column in
old$ Mandatory Text Existing column name
new$ Mandatory Text New column name

Examples:

SELECT rename_column('mytable','old','new'); -- renames column 'old' to 'new'

Tips:

  • The star$columns view lists known columns in existing tables 
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk