I would like to create a table in a SQLite database using Server Explorer in VS2008. I can perform other database operations, but when it comes to creating a table using the query builder, I get Not Supported messages. is there any other way than writing code for the sole purpose of creating a table?
CREATE TABLE myTable
(
ID INTEGER PRIMARY KEY AUTOINCREMENT,
Name VARCHAR(100)
)
.NET Framework Data Provider for SQLite 3.6.16
source
share