Charles,
You need to drop your constraints from the table definitions, fix the data
and then put the constraints back on the tables.
ALTER TABLE tblname DROP ----------- colname ----
�+ COLUMN + �
+- CONSTRAINT conname -�
+ CASCADE -------------�
+ TRIGGER ---------�
+ INSERT �
+ UPDATE �
+ DELETE +
Troy Sosamon
===== Original Message from [EMAIL PROTECTED] at 10/18/02 12:46 pm
>I have an interesting issue -
>
>I have a table called 'employees' which has EMPID set as a primary key
>I have another table called 'qualified_master' which has EMPID as a foreign
>key that references 'employees'
>
>Well, since mistakes happen, an employee was entered with the wrong EMPID in
>both the 'employees' table, and also had entries entered into the
>'qualified_master' and 'qualified_details' tables.
>
>Because of the constraint, I cannot update the EMPID in either table! Is
>there a way to change it I am not seeing, short of deleting the rows in the
>'qualified_master' and 'qualified_detail' tables? That is my last resort
>because there is a lot of data in those tables tied to this particular
>employee.
>
>Thanks!
>Charles Sikora
>Coordinator, Gas Storage
>Manlove Field
>Peoples Energy Corporation
>
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: INTRO rbase-l
>================================================
>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: UNSUBSCRIBE rbase-l
>================================================
>TO SEARCH ARCHIVES:
>http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
