Cannot delete fields (M2O)

[marco-land]

Preflight Checklist

• I have completed all Troubleshooting Steps.
• I'm on the latest version of Directus.
• There's no other issue that already describes my problem.

Describe the Bug

Created M2O fields cannot be deleted

To Reproduce

Create a Many-to-one field and save it, right after that try to delete it.

Errors Shown

{
  "errors": [
    {
      "message": "alter table `Places` drop `Test` - ER_DROP_INDEX_FK: Cannot drop index 'places_test_foreign': needed in a foreign key constraint",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ]
}

What version of Directus are you using?

9.6.0

What version of Node.js are you using?

12.22.7

What database are you using?

mySQL

What browser are you using?

Chrome

What operating system are you using?

macOS Monterey (12)

How are you deploying Directus?

running locally

[marco-land]

duplicate #11510