How do I add a index column to a database with non unique columns Furthermore: how does your table look like, what sort of index do you need, what sort of PK do you need etc. Your question will now be closed for being unanswerable because of the lack of detail. Once you edit in these (and probably others), you can request the reopening.