I'm unable to delete image fields

[gustavo-h-freitas]

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

Try creating a image field on directus, then try to delete it, it will drop this error message (allways)

{
  "errors": [
    {
      "message": "alter table `products_and_solutions_categories` drop `featured_image` - ER_FK_COLUMN_CANNOT_DROP: Cannot drop column 'featured_image': needed in a foreign key constraint 'products_and_solutions_categories_featured_image_foreign'",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ]
}

To Reproduce

Try creating a image field on directus, then try to delete it, it will drop this error message (allways)

Errors Shown

{
  "errors": [
    {
      "message": "alter table `products_and_solutions_categories` drop `featured_image` - ER_FK_COLUMN_CANNOT_DROP: Cannot drop column 'featured_image': needed in a foreign key constraint 'products_and_solutions_categories_featured_image_foreign'",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ]
}

What version of Directus are you using?

9.5.1

What version of Node.js are you using?

16.13.2

What database are you using?

sql

What browser are you using?

chrome

What operating system are you using?

Linux 4.14.252-195.483.amzn2.x86_64

How are you deploying Directus?

Docker

[rijkvanzanten]

What database vendor are you using @roceroo?

[martijn-dev]

I think this issue is related to #11510. The issue exists since 9.5.1 and is still there in the newest 9.6 version.

[rijkvanzanten]

Ah yeah good one. Duplicate of #11510