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:

 

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk