添加主键
ALTER TABLE table_name
ADD (CONSTRAINT "PK_ID" PRIMARY KEY("ID")) 添加外键
ALTER TABLE table2
ADD (CONSTRAINT "FK_ID" FOREIGN KEY("ID")
REFERENCES table1("ID"))
ALTER TABLE table_name
ADD (CONSTRAINT "PK_ID" PRIMARY KEY("ID")) 添加外键
ALTER TABLE table2
ADD (CONSTRAINT "FK_ID" FOREIGN KEY("ID")
REFERENCES table1("ID"))
ADD (CONSTRAINT "AAAA_PK" PRIMARY KEY("A"))
或者
alter table aaaa add primary key(a);ALTER TABLE "MS"."AAAA"
ADD (CONSTRAINT "SDFS" FOREIGN KEY("A")
REFERENCES "MS"."AAAAA"("A")
ON DELETE CASCADE)
或者
alter table aaaaa add foreign key(a) references aaaa(a) on delete cascade;