How to generate unique code in sqlite?

Question

How to create unequal index in sqlite?

I am using vb.net to create tables.

+2

Sein kraft May 19 '10 at 15:49

1 answer

Garett · Accepted Answer · 2010-05-19T15:57:24+0000

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

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