Unable to delete Dataverse when a row exists in the metrics table

[stevenwinship]

Due to a foreign key in DB table 'metric' a Dataverse can not be deleted via the UI when a metric exists.
The delete functionality must also delete any rows from the metric table.

• To whom does it occur (all users, curators, superusers)? All users

[qqmyers]

Related: https://groups.google.com/g/dataverse-community/c/WpfCKOxq2gE/m/5yHJ044CAgAJ