CODEWITHSUNDEEP
vb.netsqliteindexing
Sein Kraft
Sein Kraft

Reputation: 8815

How to create a non-unique index in sqlite?

How to create a non-unique index in sqlite?

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

Upvotes: 5

Views: 5686

Answers (1)

Garett
Garett

Reputation: 16828

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.

Upvotes: 5

Related Questions