Which of the following statements can be used to drop a trigger named trigger l on table tabiel in the test database?
Assume that test is the default database.
A.
DROP TRIGGER tabiel.trigger1
B.
DROP TRIGGER test.triggerl
C.
ROP TRIGGER triggerl ON tabiel
Explanation:
DROP TRIGGER database.trigger_name. Trigger is associated with table, but it belongs to database.
— INFORMATION_SCHEMA.Triggers has no reference to table for TRIGGERS, only refers to TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION etc.