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.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk