How to create a non-unique index in sqlite?

Question

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

Garett · Accepted Answer · 2010-05-19 16:23:47Z

5

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.

edited May 19, 2010 at 16:23

answered May 19, 2010 at 15:57

Garett

16.9k5 gold badges58 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a non-unique index in sqlite?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related