On 21 Aug 2013, at 11:49pm, veeresh kumar <[email protected]> wrote:
> Is there a way to disable/enable specific foreign key constraint in sqlite3? > Below is the sqlserver query , would like to know similar query in sqlite 3 > > ALTER TABLE tablename WITH NOCHECK NOCHECK CONSTRAINT FK_Column No, sorry. You can disable all foreign key checking: <http://www.sqlite.org/pragma.html#pragma_foreign_keys> but not a specific key. If you need to put data in but not have it checked until COMMIT you might be interested in deferred checking: <http://www.sqlite.org/foreignkeys.html#fk_deferred> Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
