When does Auditor create SQL triggers?

When does Auditor create SQL triggers?

Auditor only creates SQL Triggers if you have set up SQL Table Audits.  If you have set up other audit types, then only Dexterity triggers are created.