「Oracle」トリガー(trigger)を削除する方法

1.トリガーを確認

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
*
FROM
USER_TRIGGERS
where
TRIGGER_NAME = 'TRG_USER_INFO_LOCK_I';
SELECT * FROM USER_TRIGGERS where TRIGGER_NAME = 'TRG_USER_INFO_LOCK_I';
SELECT
  * 
FROM
  USER_TRIGGERS 
where
  TRIGGER_NAME = 'TRG_USER_INFO_LOCK_I';

2.トリガーを削除

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
DROP TRIGGER TRG_USER_INFO_LOCK_I
DROP TRIGGER TRG_USER_INFO_LOCK_I
DROP TRIGGER TRG_USER_INFO_LOCK_I

 

Oracle

Posted by arkgame