删除主键
Alter table 表名 Drop Constraint Primary Key
添加主键
Alter table 表名 Add Constraint PrimaryKey Primary Key (主键字段名)
撤消主键
alter table [Student] drop primary key (S_id)
增加主键
alter table [Student] add primary key (S_id)
删除主键
Alter table 表名 Drop Constraint Primary Key
添加主键
Alter table 表名 Add Constraint PrimaryKey Primary Key (主键字段名)
撤消主键
alter table [Student] drop primary key (S_id)
增加主键
alter table [Student] add primary key (S_id)