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.


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


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.


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


Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk