SQLite Forum

Delete columns??
Login
Hi,

I have a table "Words" with primary key autoincrement. 
Another table "Translated" related to the table "Words" through the primary key of "Words"
I need to delete some columns in the table "Words" but in sqlite this is not possible directly. So I have created a new table "Words2" without the unwanted columns and I want to transfer the relevant columns to my new table "Words2".

A few questions:
How do you suggest this is done? 
Is it recommended to use autoincrement in a relational databse?

Best Regards
Lars Frederiksen