How to create a non-unique index in sqlite?

Question

How to create a non-unique index in sqlite?

I'm using vb.net to create the tables.

Answer 1

To create a non-unique index you would use the CREATE INDEX statement without the UNIQUE keyword. See the documentation for more information.

http://www.sqlite.org/lang_createindex.html

UPDATE: If you are using the System.Data.SQLite provider, it has design time support in Visual Studio, so you can use it to create your indexes via Visual Studio.