On Dec 30, 2003, at 3:12 PM, Kurt Welgehausen wrote:
... are UNIQUE columns basically the same as PRIMARY KEY ...?
No, they're not the same thing.
I understand that they are not the same thing in SQL. What I want to know is whether or not applying UNIQUE and PRIMARY KEY amount to the same thing *in SQLite*. Because if they are functionally the same *in SQLite* (and I think, right now, that they are) then it might be interesting to request that UNIQUE columns be marked as PRIMARY KEYs in the table_info(). Of course, the fact that they aren't really the same thing in SQL may be one good reason not to have such a feature. But then perhaps we should have an extra column in table_info that indicates whether or not a given table column is UNIQUE. Right now, short of parsing the SQL that creates a table, I can't identify UNIQUE columns in a table.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
