Re: [sqlite] primary key is indexed by default ?

Richard Kim <[EMAIL PROTECTED]> wrote: > Just wondering that if you set primary key in table, the column is > indexed by default in sqlite ? Yes. PRIMARY KEY and UNIQUE constraints are enforced by automatically generating a unique index. Igor Tandetnik

[sqlite] primary key is indexed by default ?

Hi Just wondering that if you set primary key in table, the column is indexed by default in sqlite ? thanks a lot Richard K ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users