Drop function in oracle-Oracle-php.cn

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 ;Object types include TABLE, VIEW, INDEX, and TRIGGER. Use the CASCADE keyword to cascade the deletion of dependent objects.

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

DROP ; 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":

DROP TABLE customers; Delete the table named View of "customer_view":

DROP VIEW customer_view; Delete the index named "customer_idx":

DROP INDEX customer_idx; Cascade delete named "customer_trigger" Triggers and their dependent objects:

DROP TRIGGER customer_trigger CASCADE;

Drop function in oracle

Hot AI Tools

Undress AI Tool

Undresser.AI Undress

AI Clothes Remover

Clothoff.io

Video Face Swap

Hot Article

Hot Tools

Notepad++7.3.1

SublimeText3 Chinese version

Zend Studio 13.0.1

Dreamweaver CS6

SublimeText3 Mac version

Hot Topics