>
> there can be many such tables that have foreign key id which is referencing
> the master table test_master column "id". what we want is when some ids become
^^^
It should be profile_master, right?
> redundant we have to merge two ids , we want that thru out the sy
yes you got my problem rightly.
If i use "on update cascade" approach still
there is problem.
If i attempt to update the key in master table it
wont be allowed becoz of temporary violation of
PRIMARY KEY CONSTRAINT.
becoz 1 is also existing in the master table.
update profile_master set id=
Rajesh Kumar Mallah. wrote:
Hi we are working on re-structuring our database schemas and
intend to implement the functionality below at database level.
consider a master table with following data.
Table: profile_master
id | username | password
---|--|--
1 | u1
Hi we are working on re-structuring our database schemas and
intend to implement the functionality below at database level.
consider a master table with following data.
Table: profile_master
id | username | password
---|--|--
1 | u1 | p1
2 | u2 | p2
