Drop function in oracle

The DROP command in Oracle can delete database objects (tables, views, indexes, triggers). This command cannot be reversed and will delete all dependent objects. Usage: DROP

The role of DROP command in Oracle

The DROP command is used to delete database objects, such as tables, from the Oracle database , views, indexes and triggers.

Usage

<code>DROP  ;</code>

Object Type

• TABLE: Delete table.
• VIEW: Delete the view.
• INDEX: Delete index.
• TRIGGER: Delete trigger.

Explanation

• The DROP command is irreversible, and the deleted objects cannot be recovered.
• The DROP command will also delete all dependent objects associated with the object.
• Use the CASCADE keyword to cascade deleted dependent objects.
• If the object is in use, it cannot be deleted.

Example

Delete the table named "customers":

<code>DROP TABLE customers;</code>

Delete the table named View of "customer_view":

<code>DROP VIEW customer_view;</code>

Delete the index named "customer_idx":

<code>DROP INDEX customer_idx;</code>

Cascade delete named "customer_trigger" Triggers and their dependent objects:

<code>DROP TRIGGER customer_trigger CASCADE;</code>

The above is the detailed content of Drop function in oracle. For more information, please follow other related articles on the PHP Chinese website!