create table ghy1(
ghy1 int primary key,
ghy2 char(10)
)
create table ghy2(
ghy11 int,
ghy1 int
)ALTER TABLE ghy1 ADD CONSTRAINT table_ghy1_constraint FOREIGN KEY (ghy1)
REFERENCES ghy1(ghy1)这样写对吗??感谢。
ghy1 int primary key,
ghy2 char(10)
)
create table ghy2(
ghy11 int,
ghy1 int
)ALTER TABLE ghy1 ADD CONSTRAINT table_ghy1_constraint FOREIGN KEY (ghy1)
REFERENCES ghy1(ghy1)这样写对吗??感谢。
create table ghy1(
ghy1 int primary key,
ghy2 char(10)
)
create table ghy2(
ghy11 int,
ghy1 int
)ALTER TABLE ghy2 --更改之处
ADD
CONSTRAINT table_ghy1_constraint FOREIGN KEY (ghy1)
REFERENCES ghy1(ghy1)
ADD
CONSTRAINT table_ghy1_constraint FOREIGN KEY (ghy11) --修改之处
REFERENCES ghy1(ghy1)