Question

my SQL删除主键的语句？？？

alter table 表名 drop primary key(字段名)
是这样写的吗？
alter table student drop primary key (id);

alter table student drop primary key id;

alter table student drop primary key ‘id’;
怎么写呀，高手们，帮帮我吧，用了很多种方法都不对，
建表时用的语句是这样的：
CREATE TABLE Student (name varchar(20),id varchar(20) PRIMARY KEY,sex char(2),age int);
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'primary key' at line 1

Answer 1

alter table 表名 drop PRIMARY key;