drop

Deletes a table, a user or a broker.

Syntax

drop table TABLE_NAME;
drop user NAME [cascade];
drop databroker NAME;
drop masterbroker NAME;
drop synsqlbroker NAME;

drop table

• A table that is not deployed is only removed from the dictionary. A deployed table is also removed from all its segments, on all the data brokers.
• You need the DROP privilege on the table. The owner has it.
• One table at a time. A table that is referenced by a foreign key must be freed from it first.
• It cannot be undone. If you may need the data, take a dump first (see dump).

The other forms

See Manage users for drop user and Manage brokers for the brokers. They need an administrator account.