SQL Trigger Generator
Generate CREATE TRIGGER statements for PostgreSQL, MySQL, SQLite, SQL Server, and Oracle. Pick a pattern, customize, and copy the code.
1. Choose Pattern
Tracks INSERT, UPDATE, DELETE on a table into an audit log table with who and when.
2. Dialect & Settings
3. Generated SQL
-- Select a pattern and configure settings above
Quick Examples
Users Audit Log
Track every change on a users table into an audit table.
PostgreSQLAudit
Products Updated At
Automatically set updated_at before every UPDATE.
MySQLTimestamp
Orders Prevent Delete
Block DELETE operations on an orders table entirely.
SQL ServerSecurity