I'm sure this will be a no brainer for people in this forum.
I have a small database of products. I want to add a field, called product_id, to the database, so that every product now has an incremental product_id.
The original designer did not add this field when he created the database, and removing products is VERY ugly right now.