Re: [sqlite] primary, secondary keys

[David M. Cook]

On Fri, Sep 30, 2005 at 10:55:07AM -0400, Mark Wyszomierski wrote:

>  Does sqlite allow multiple keys? When I created a table I did:
>   CREATE TABLE test (name, address, fav_color, primary key(name, address))

I usually use UNIQUE, though, for "business keys", and reserve PRIMARY KEY
for the auto-increment field.

Dave Cook