[Oracle] 外來鍵約束 FK Constraint

Una
1 min readSep 14, 2019

--

FOREIGN KEY約束

Keywords

  • FOREIGN KEY:設定外來鍵
  • REFERENCES:標識父表中的表和列
  • ON DELETE CASCADE:刪除父表中的行時刪除子表中的相關行
  • ON DELETE SET NULL:將相關外鍵值轉換為空值

--

--

Una
Una

Written by Una

Hello. This is my code note.

No responses yet