Quoth Igor Tandetnik <itandet...@mvps.org>, on 2010-12-26 14:39:15 -0500:
[quoting the documentation]
> Each table in SQLite may have at most one PRIMARY KEY. If the
> keywords PRIMARY KEY are added to a column definition, then the
> primary key for the table consists of that single column. Or, if a
> PRIMARY KEY clause is specified as a table-constraint, then the
> primary key of the table consists of the list of columns specified
> as part of the PRIMARY KEY clause.
>
> A UNIQUE constraint is similar to a PRIMARY KEY constraint, except
> that a single table may have any number of UNIQUE constraints.

Oh, _there_ it is.  So it is written explicitly, just a little bit
compressed.  I was foolish and didn't link the latter paragraph to the
former when doing textual search.  Hmm.

   ---> Drake Wilson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to