On 17 Mar 2017, at 7:49am, Dominique Devienne <ddevie...@gmail.com> wrote:

> Richard, why is SQLite ignoring an attempt to giving these an explicit
> name? —DD
> 
> […]
> 
> sqlite> create table t (id constraint u1 unique);

You are supplying a name for the constraint.  But you’re still leaving it up to 
SQLite to create the index it will need.  So SQLite gets to choose the name for 
the index.  If you want to supply the name yourself you have to define the 
index yourself.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to