25

I can not drop a trigger, but when I try to create a new one with same name — it alerts me that trigger exists. So, I want to list all the triggers, to figure out what's wrong.

waiter.james
  • 591
  • 2
  • 6
  • 16

1 Answers1

57

You can get all of the data relating to triggers using the sqlite_master table (this includes the ddl code to create them). If you don't want all of the data just leave off some of the columns in your query.

For all data:

select * from sqlite_master where type = 'trigger';

For just a list of names:

select name from sqlite_master where type = 'trigger';
ChrisProsser
  • 12,598
  • 6
  • 35
  • 44
  • 3
    For those who, like me, do/did not know what sqlite_master is, see [this link](https://renenyffenegger.ch/notes/development/databases/SQLite/internals/schema-objects/sqlite_master/index). – Lfppfs Dec 23 '21 at 18:00