Help us understand the problem. What is going on with this article?

Oracleで外部キー制約が設定されているテーブルを削除する方法

More than 3 years have passed since last update.

環境

  • OS:Windows 8.1 Pro 64bit
  • DB:Oracle Database 10g Release 10.2.0.5.0 - 64bit Production

エラー内容

外部キー制約を設定している親テーブルをDROP TABLE {テーブル名}で削除しようとすると、以下のエラーが発生して削除に失敗します。

ORA-02449: 表の一意キーまたは主キーが外部キーに参照されています。

対応

外部キー制約ごとであれば削除することができます。
「CASCADE CONSTRAINTS」を末尾に付ければ、制約ごとテーブルを削除できます。

-- 制約ごとテーブルを削除する
DROP TABLE {テーブル名} CASCADE CONSTRAINTS;

参考リンク

uhooi
iOSアプリ開発とSwiftが好きです✨ 趣味:テニス、アナログゲーム
https://theuhooi.com
Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした