another way
"SELECT rowid FROM MyTable LIMIT 1"
the column name returned will be the Integer Primary Key
StanD
sd at sqlight.com
----- Original Message -----
From: "Mario Frasca" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, August 07, 2006 9:33 AM
Subject: Re: [sqlite] primary key information
Nemanja Corlija wrote:
I think in any other case unique index would be created as expected.
sqlite> drop table test;
sqlite> create table test (ni integer, pk_name varchar(32) primary key,
info integer);
sqlite> pragma index_list(test);
0|sqlite_autoindex_test_1|1
sqlite> pragma table_info(test);
0|ni|integer|0||0
1|pk_name|varchar(32)|0||1
2|info|integer|0||0
sqlite>
that seems to be correct... interesting, thanks,
Mario
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.7/410 - Release Date: 8/5/2006
