Regarding: I can't use command line utility as I do this on a smartphone device. and I am using sqlite by c# the Ado .Net library which is very new to me and I can for now only execute insert,delete,update and basic commandtext queries.
------ Well, you might have to resort to a more complex method. The following queries may be of help -- they might be part of general "DropAllTriggers" and a "RecreateAllTriggers" subroutines. -- Build SQL to re-create all triggers select sql as BuildSQL from sqlite_master where type= 'trigger'; -- Build SQL to drop all triggers in current database select 'DROP TRIGGER ' || name || ';' as DropSQL from sqlite_master where type= 'trigger'; You may even find that ability to read sql from a file is so useful that you want to implement it within your ADO application. This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users