「Oracle」トリガー(trigger)を削除する方法
1.トリガーを確認
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.トリガーを削除
DROP TRIGGER TRG_USER_INFO_LOCK_I
DROP TRIGGER TRG_USER_INFO_LOCK_I
DROP TRIGGER TRG_USER_INFO_LOCK_I