drop_table

Drops an existing database table.

Note that a local table cannot be dropped if it has a port defined for it.

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

Parameters:

Name	Optional	Type	Description
table$	Mandatory	Text	The name of the database table to be dropped.
cascade$	Mandatory	Boolean	Indicates if dependent objects can be dropped.

Examples:

SELECT drop_table('mytable',true); -- drops table 'mytable' and any dependent objects.

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

Tips:

• The star$tables view indicates which tables exist.