create_column

Creates a new column in a database table. The column specification contains a column name, data type with an optional default and check constraint for the new column – using the same syntax as the column specification in a SQL CREATE TABLE statement.

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

Parameters:

Name Optional Type Description
table$ Mandatory Text The table to add the column to.
column$ Mandatory Text Column specification for the new column.

Examples:

SELECT create_column('mytable','notes text');  -- creates column 'notes' in table 'mytable'.

SELECT create_column('mytable','count int default 0');  -- creates column 'count' with a default value.

Tips:

  • The star$columns view lists existing columns in each table

 

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk