1. drop the existing primary key, use
ALTER TABLE Table_Name DROP PRIMARY KEY;

2. add new primary key, use
ALTER TABLE Table_Name ADD PRIMARY KEY (Column1, Column2, ...);

mark528 發表在 痞客邦 PIXNET 留言(0) 人氣()