如何在phpmyadmin表中删除多个主键? [英] How can I drop multiple primary keys in phpmyadmin tables?

问题描述

我正在使用phpmyadmin.我创建了一个带有一个主键和5个字段的表.但是现在所有的整数字段都变成了主键.我尝试使用drop命令，但无济于事.如何从表中删除所有主键?

I am working with phpmyadmin.I created a table with one primary key and 5 fields. But now all the integer fields have turned into a primary key. I tried using drop command but it doesn't help. How can I remove all primary keys from the table?

推荐答案

只需打开phpmyadmin表上的Structure选项卡.在结构描述之后，应该有一个Indexes部分，您将在其中看到所有索引，包括主键.您可以在其中修改或删除可能已定义的任何主键.

Just open up the Structure tab on your phpmyadmin table. After the structure description, there should be a Indexes section where you'll see all indexes, including your primary keys. There you'll be able to either modify or remove any primary key you may have defined.

----编辑----

这篇关于如何在phpmyadmin表中删除多个主键?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！