On Oct 16, 2006, at 11:46 AM, Marco Bambini wrote:
Not sure to understand what you mean, but after this statement:
CREATE TABLE foo (uniqueID integer PRIMARY KEY AUTOINCREMENT, ...)
rowid is just an alias to the uniqueID column.
It still exists.
What I mean is that a person should ALWAYS define a primary key and
not simply rely on the row id hoping that it will be unique.
Some databases do guarantee that the row id will be a unique,
strictly increasing sequence that you could use reliably. Some don't.
SQLite, by default, does not.
It's good database design to do define a primary key for every table
you create.
Assuming the engine has created one for you may lead to unexpected
results.
That's all.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
