Description

Deleting a specified object refers to removing an existing database object in the database, such as a table, view, index, function, etc. This operation is irreversible; once executed, the deleted object and all its data will be permanently removed from the database.

Syntax

DROP <object_type> [ IF EXISTS ] <identifier>

• DROP: Keyword, indicates the execution of a delete operation.
• <object_type>: The type of object to be deleted, such as TABLE, VIEW, INDEX, FUNCTION, etc.
• IF EXISTS: Optional clause, if the specified object exists, the delete operation is executed; if it does not exist, no operation is performed and no error is thrown.
• <identifier>: The name of the specific object to be deleted, such as table name, view name, etc.

Specific Syntax Reference

DROP USER

DROP ROLE

DROP CONNECTION

DROP SCHEMA

DROP SCHEMA

DROP SHARE

DROP VCLUSTER

DROP TABLE

DROP DYNAMIC TABLE

DROP VIEW

DROP MATERIALIZED VIEW

DROP INDEX

DROP TABLE STREAM

DROP SYNONYM

DROP FUNCTION