Name

DROP TRIGGER

Synopsis

DROP TRIGGER
[schema.]trigger_name

Removes a trigger (trigger_name) from the database.

Note

The trigger to be dropped must be in your schema, or you must have the DROP ANY TRIGGER privilege, to remove a trigger from another schema.

Example

The following example removes the inventory_low trigger from the database:

DROP TRIGGER inventory_low
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset