If you have a Primary Key created in a table, is it necessary to generate an Index in that table? Because a primary key is a type of index you do in a sense create a index with the primary key, however you do not need a separate index for this. Remember that you can only have 1 primary key per table. If you have any suggestions for or problems with this website, please e-mail support@mercuryd.com