单选题

The my_table table has an existing primary key. You want my_id to become the new primary key. Which statement will replace the old primary key with the new one?

AALTER TABLE my_table REPLACE PRIMARY KEY WITH my_id;

BALTER TABLE my_table DROP PRIMARY KEY, ADD PRIMARY KEY (my_id);

CALTER TABLE my_table DROP PRIMARY KEY; CREATE PRIMARY INDEX my_table(my_id);

DRREATE PRIMARY INDEX my_table (my_id) REPLACE PRIMARY KEY;

查看答案

正确答案：A （备注：此答案有误）

相似试题

单选题

The my_table table has an existing primary key. You want my_id to become the new primary key. Which statement will replace the old primary key with the new one?

答案解析
单选题

THE INDICATIONS MUST AGREE WITH THE VALUES IN THE TABLE.

答案解析
单选题

This table that follows shows the data

答案解析
问答题

There was an ﹍ table in the dining room.

答案解析
单选题

Food that（）easily must reach the market and the dinner table as quickly as possible.

答案解析