Hi Sean, In reply to:
> In postgres, I know that if I declare a column or set of columns to have a > unique constraint, there is also an index created on those columns. Does the > same thing happen in sqlite Yes. For example: create table Test (Name text collate nocase unique not null); gives: select * from SQLite_Master; type|name|tbl_name|rootpage|sql table|Test|Test|15|CREATE TABLE Test (Name text collate nocase unique not null) index|sqlite_autoindex_Test_1|Test|16| Tom Tom Brodhurst-Hill BareFeetWare -- iPhone/iPad/iPod and Mac software development, specialising in databases develo...@barefeetware.com -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
