picoSQL - Language reference manual

Syntax:

DROP { INDEX index-name | TABLE table-name | VIEW view-name }

Purpose:

Allows to drop an index, a table or a logical view.

See also:

CREATE INDEX, CREATE TABLE, CREATE VIEW

Description:

This statement drop an index, a table or a view from the database.

Dropping an index, the freed space remains allocated and it is use for the remaining indexes or for new indexes.

Dropping a table, the freed space is immediately released to the operating system and can be used by other application too.

Dropping a view, the small freed space can be reused only for creating other views.