drop_column

Drops a column from a table.

Note that a column cannot be dropped if it is referenced by a port definition.

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

Parameters:

Name	Optional	Type	Description
table$	Mandatory	Text	The table to drop the column from.
column$	Mandatory	Text	The column to be dropped.
cascade$	Mandatory	Boolean	Indicates if dependent objects can be dropped.

Examples:

SELECT drop_column('mytable','mycol',true); -- drops column 'mycol' from table 'mytable'.

SELECT drop_table('mytable','mycol',false); -- drops column 'mycol' if no dependent objects.

Tips:

• The star$columns view indicates which columns exist in each table.