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
Explanation
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!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
