Is there any way to use the SqliteExplorer to make a column a primary key as can be done in SQL Server 2000, Oracle , or Access interfaces? Thank Steve
Not directly.
Copy your existing table into a temp table, drop the existing table, create a new table with the same name as the existing table but declare the appropriate column as the primary key, finally copy the data back from the temp table into the new empty table.
HTH
Dennis Cote
