简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Oracle > body text

Drop function in oracle

下次还敢
Release： 2024-05-08 20:00:25
Original
518 people have browsed it

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.

Drop function in oracle

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>
Copy after login

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>
Copy after login

Delete the table named View of "customer_view": 

<code>DROP VIEW customer_view;</code>
Copy after login

Delete the index named "customer_idx": 

<code>DROP INDEX customer_idx;</code>
Copy after login

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

<code>DROP TRIGGER customer_trigger CASCADE;</code>
Copy after login

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

Related labels：
oracle
source：php.cn
Previous article：interval usage in oracle Next article：What does (+ mean in oracle
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
From 2024-04-04 18:17:27
0
1
3567
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！