A trigger in SQL is a special type of stored procedure that automatically executes in response to specific database events like INSERT, UPDATE, or DELETE operations on a table. Unlike regular stored procedures that must be called explicitly, triggers fire automatically when their defined event occurs.