I have the same question. Specifically, what indication is there that no primary key was created.
Certainly, by executing the command below (using the sqlite3 command tool) verbatim and following that with ".schema" indicates that the table was created with a primary key. This is with 3.2.7 on Windows XP. On Mon, 28 Nov 2005, Will Leshner wrote: > > On Nov 28, 2005, at 6:39 PM, Bogdan Ureche wrote: > > > CREATE TABLE TestTable (TestField1 INTEGER PRIMARY KEY, TestField2 > > VARCHAR) > > > Does the table itself get created? It is impossible to have a table > without an INTEGER PRIMARY KEY in SQLite, so it is hard to believe > that you can create the table without an INTEGER PRIMARY KEY. How can > you tell the key isn't created? >
