I want to delete the credit card number from the database kept on the server for security purposes. I used a cfquery
<CFQUERY NAME="DeleteCrNo" datasource="database">
DELETE No FROM CustTable
but the table is related to another table and I get an error cannot be deleted or changed because table 'sales' includes related records.
Can someone tell me how to delete the data from this field?