Good stuff Keith. One to archive.
From: sqlite-users on behalf of
Keith Medcalf
Sent: Tuesday, November 28, 2017 4:02:35 PM
To: SQLite mailing list
Subject: Re: [sqlite] Foreign key help
And of course in the command line shell you can and should use
.lint
And of course in the command line shell you can and should use
.lint fkey-indexes
to let you know if you are missing any indexes required for efficient
foreign-key enforcement operations.
It will report missing indexes on the PARENT (table/columns referred to) and on
CHILDREN (tables/columns
Thanks David / Simon.
From: sqlite-users on behalf of
Simon Slavin
Sent: Tuesday, November 28, 2017 3:36:51 PM
To: SQLite mailing list
Subject: Re: [sqlite] Foreign key help
On 28 Nov 2017, at 3:26pm, x wrote:
> If I have foreign keys in place but alw
mailinglists.sqlite.org] On
Behalf Of x
Sent: Tuesday, November 28, 2017 10:27 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Foreign key help
If I have foreign keys in place but always have foreign_keys = OFF then one day
start SQLite with foreign_keys = ON what happens? Does SQL
On 28 Nov 2017, at 3:26pm, x wrote:
> If I have foreign keys in place but always have foreign_keys = OFF then one
> day start SQLite with foreign_keys = ON what happens? Does SQLite suddenly
> check all foreign keys and report / delete violations or does it leave
> everything as is and just en
If I have foreign keys in place but always have foreign_keys = OFF then one day
start SQLite with foreign_keys = ON what happens? Does SQLite suddenly check
all foreign keys and report / delete violations or does it leave everything as
is and just enforce foreign keys from that point on?
__
6 matches
Mail list logo
