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.


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.


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.


  • The star$columns view indicates which columns exist in each table.
Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk