-- Add the new column
-- Make sure it doesn't have any nulls in it
ALTER TABLE mytable ADD newcolumn NUMBER(10) NOT NULL DEFAULT 1;
-- Drop the primary key
ALTER TABLE mytable DROP PRIMARY KEY;
-- Add a new primary key
ALTER TABLE mytable ADD CONSTRAINT mytable_pk
PRIMARY KEY (oldcolumn1, oldcolumn2, newcolumn);
1 回答
您必须删除现有主键并创建一个新主键 . 请注意,主键列不能是
null
. 例如 . :