| constrain creationg problem on child table [message #311069] |
Thu, 03 April 2008 05:58  |
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
|
Senior Member |
|
|
Hello,
I have two tables prcmain,prcitem
previously(old one)
prcmain - prmariykey - unitid,prc_number
prcitem - referencial key - prcmain(unitid,prc_number);
new one (needed)
prcmain - prmariykey - unitid,prc_number,prc_date
prcitem - referencial key - prcmain(unitid,prc_number,prc_Date);
Now
I want to change the primary key of prmain(unitid,prc_number,prc_date) now
First i drop the foreign key in prcitem the old one
and alter the table to add new constrain in prcmain.
which is done properly.
But when i doing referencial constraints in prcitem. im getting problem.
|
|
|
|
| Re: constrain creationg problem on child table [message #311072 is a reply to message #311069] |
Thu, 03 April 2008 06:08  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
| Quote: | But when i doing referencial constraints in prcitem. im getting problem.
|
85 posts and you still post stuff like this? What problem? An error? Unexpected results. Aliens come down and abduct you? The end of life as we know it? Your missing sock turns up (but in a different colour)?
You
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
