It's because there are other records using/referring to that contact. So in order to delete it, you first have to delete all the child elements or records that are associated with it, and then only you can delete this record. As the ON DELETE CASCADE is not there for the constraint, hence the child elements/records are getting deleted.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 12/23/13, 9:37 AM|
|Seen: 741 times|
|Last updated: 3/16/15, 8:10 AM|