All,

Is there a way to alter a database via the SOPM to change a FK relationship? 

I found that I was unable to delete tickets in the system (we have a queue for deleting junky/spam tickets) when one of our custom integrations already had a db entry for it.

Here is the setup

Cost_estimate => FK relationship on ticket_id

So when I try to delete a ticket in the system, the system complains that it’s violating the FK relationship on cost_estimate.

I need to update the SOPM to alter the key relationship so that deletes are okay (and will cascade/delete entries from the cost_estimates database).

Additionally I need to update the TableCreate statement to include a proper FK relationship.  How do I do this??

Best Regards,

Mike