i'm using VS2008 and SQLite-1.0.66.0-setup.exe.
I want to let the primary key in the table to be auto increment, but I could not find how to set in the designer.
i'v found the same question at http://sqlite.phxsoftware.com/forums/p/1553/6744.aspx#6744, The answer there is "found it under Index / Keys". At my side, there are "Columns", "Indexes", "Foreign Keys" and "Triggers" under my table name, and there is only one item "sqlite_master_PK_bom" under "Indexes", (bom is my table name).
Later, I found the auto increment can be set at *DataSet.xsd. But I still hope to know how to set it in the designer, because sometimes I writes the dataAdapter, dataSet... manually, there will be no file *DataSet.xsd. Thanks.