How can I list all the triggers of a database in sqlite?

sqlite android-sqlite sqliteopenhelper
waiter.james picture waiter.james · Sep 6, 2013 · Viewed 10.4k times · Source

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.

Answer

ChrisProsser picture ChrisProsser · Sep 6, 2013

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';

Related questions

When is SQLiteOpenHelper onCreate() / onUpgrade() run?

I have created my tables in my SQLiteOpenHelper onCreate() but receive SQLiteException: no such table or SQLiteException: no such column errors. Why? NOTE: (This is the amalgamated summary of tens of similar questions every week. Attempting to provide a "canonical" …

Read More
Insert JSON data into the SQLite database in android

I want to insert the data from JSON array into the SQLite database. I have created two classes CategoryHelper.java and AndroidJSONParsingActivity.java to get the java response. When I run the code got the exception in databaseHelper.saveCategoryRecord(id,…

Read More
android.database.sqlite.SQLiteException: no such column : id (code 1) while compiling : s

following error found when I click on "Insert" button Error Found :android.database.sqlite.SQLiteException: no such column : id (code 1) while compiling : select id,student_name, student_rollno FROM studentTable WHERE idrh Error Found :android.database.sqlite.SQLiteException: no such …

Read More