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.
----- Original Message ----- From: "Griggs, Donald" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Thursday, August 14, 2008 5:12 PM Subject: Re: [sqlite] is there a pragma to disable triggers? > Regarding: Is there a pragma to disable triggers on the sqlite > database? > > Hello Marton, > > There's no such pragma to my knowledge. See > http://www.sqlite.org/pragma.html > > Perhaps you can use the command line utility "sqlite3" to ".dump" the > schema of your database, isolate just the CREATE TRIGGER commands, and > call this file "addTriggers.sql" > > Then grep that file for just the CREATE TRIGGER first lines, and edit > these down to a "dropTriggers.sql" file. > > Now the sqlite3 ".read" command will allow you to quickly delete or > restore triggers with a simple batch file. > > > > > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
