pdm91
(Pramodmahale92)
1
I have table with:
CREATE TABLE tbl_xyz(
name VARCHAR(200) NOT NULL,
is_special BOOLEAN NOT NULL DEFAULT FALSE,
CONSTRAINT pk_xyz PRIMARY KEY (name)
);
CREATE TABLE tbl_xyz1(
name VARCHAR(200) NOT NULL,
group_id INT NOT NULL,
CONSTRAINT pk_xyz1 PRIMARY KEY (name),
CONSTRAINT fk_xyz1 FOREIGN KEY (name) REFERENCES tbl_xyz (name) ON DELETE CASCADE
);
How can i update a primary key ?
i.e.
I have 1 record in tbl_xyz:
name => abc
and i want to update "abc" to "abcd" where as abc is foreign key in tbl_xyz1.
Once i update row in tbl_xyz then tbl_xyz1 with "abc" as foreign key should also change to "abcd";
itma
(Andrzej Bernat)
2
Try to add CONSTRAINT fk_xyz2 FOREIGN KEY (name) REFERENCES tbl_xyz (name) ON UPDATE CASCADE. I think it should be a thing you are looking for.