is there anyway to add a primary autonumber key to an already existing database table
- by oo
i have inherited a database application from someone else and there are a few tables that dont have any primary keys. I want to add a new column into an already existing table and have it autonumber (starting from 1). how would i go about doing this?