when I execute this command I get this error
I thought there is some dependency or exisitng already.. for safe side.. dropped the constraint.. then the error message said
Any insight.. of the issue here?
I think the problem is that there are values in the TECHNOLOGY_UTILIZATIONADD column of INFORMATION_TECHNOLOGY_ID that aren't present in INFORMATION_TECHNOLOGY. Try this query to test:
That will show you the offending rows. You'll have to fix them before you can add the constraint.
answered Mar 26 '10 at 03:34 PM