Re: [sqlite] Get a table's primary key?

[Nuno Lucas]

Kirk Haines, dando pulos de alegria, escreveu :
On Tue, 05 Oct 2004 19:03:33 +0100, Eddy Macnaghten <[EMAIL PROTECTED]> wrote:
rowid is alsways an alias for the primary key whether an "integer
primary key" field was specified or not
But is there a way to get the name of that field?
Yes, you can use the "pk" field in "PRAGMA table_info(T)".
Regards,
~Nuno Lucas