On 2015-11-18 2:05 AM, Dominique Devienne wrote: > On Wed, Nov 18, 2015 at 10:58 AM, Darren Duncan <darren at darrenduncan.net> > wrote: > >> On 2015-11-18 1:27 AM, Yuri wrote: >>> I agree they can be beneficial, but not in all cases. Depends on what you >>> do. It >>> would have been great if it was an option, ex. "CONSTRAINT LEVEL >>> [STATEMENT|TRANSACTION];". >> >> You can declare that behavior individually per foreign key constraint, and >> you can also change it at runtime with >> https://www.sqlite.org/pragma.html#pragma_defer_foreign_keys if that's >> what you were looking for. -- Darren Duncan > > [DD] Oh, I didn't realize that pragma existed! Thanks for that. Didn't even > realize SQLite supported deferred per FK, I thought it was always for all > FKs in general. Given this pragma, then showing the FK name on immediate > mode is possible, no? --DD
Well what does https://www.sqlite.org/foreignkeys.html tell you? -- Darren Duncan