Multiple choice technology databases

which command do u used to remove trigger(business_hour) in iSQL environment ?

  1. DELETE TRIGGER business_hour

  2. DROP TRIGGER business_hour

  3. REMOVE TRIGGER business_hour

  4. ALTER TRIGGER business_hour remove
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The standard SQL command to remove a trigger is DROP TRIGGER trigger_name. DELETE is for data rows, REMOVE is not valid SQL, and ALTER TRIGGER ... REMOVE is not valid syntax.

Keep practicing — related questions