语法如下:
ALTER TABLE table_name
ADD CONSTRAINT constraint_name
[FOREIGN KEY]{(column_name[,…n])}
REFERENCES ref_table[(ref_column_name[,…n])]
实例:
alter table B
add constraint cc
foreign key (id)
references A (id)
语法如下:
ALTER TABLE table_name
ADD CONSTRAINT constraint_name
[FOREIGN KEY]{(column_name[,…n])}
REFERENCES ref_table[(ref_column_name[,…n])]
实例:
alter table B
add constraint cc
foreign key (id)
references A (id)