Re: I've created a class that generates the necessary sql statements to
describe
the primary-foreign key relationship between two tables.
Todd, I suspect there would be interest to some on the list.
You may also want to review Cody Pisto's utility linked from page:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've created a class that generates the necessary sql statements to
describe the primary-foreign key relationship between two tables. This
code is fairly rudimentary so far...
Q: Is this interesting to anyone on this list?
Q: If so, where should I
* Griggs, Donald <[EMAIL PROTECTED]> [0246 18:46]:
>
> > -Original Message-
> > From: Dick Davies [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, February 01, 2005 3:52 PM
> > To: SQLite
> > Subject: [sqlite] foreign keys? (sqlite3)
> >
> >
> > The docs seem to say sqlite3 does'nt support
> -Original Message-
> From: Dick Davies [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 01, 2005 3:52 PM
> To: SQLite
> Subject: [sqlite] foreign keys? (sqlite3)
>
>
> The docs seem to say sqlite3 does'nt support foreign keys, is
> that correct?
>
> If so, I don't understand what
Sqlite parser DOES parse foreign key constraints. Try this:
create table t1(
id integer,
id1 integer,
id2 integer,
id3 integer,
foreign key (id1,id2) references anotherTable(id,id1),
foreign key (id3) references somethingElse(id)
);
pragma foreign_key_list(t1);
However, this does not mean that
5 matches
Mail list logo