$tenant->delete() doesn't delete associated db

[skills-up]

$tenant->delete() doesn't delete associated db

[stancl]

Please take a look at how Eloquent works under the hood. This has nothing to do with tenancy.

$user->tenants()->delete() doesn't delete databases because it also doesn't trigger events. Laravel doesn't fetch each tenant to delete it individually here, it instead tells the SQL server to bulk delete tenants that match certain filters.

To delete a user's tenants with databases, you'd need to first fetch the model instances before calling delete() on them individually.

[stancl]

SQL servers can't run PHP. If you use ON DELETE CASCADE, it will be the SQL server deleting the tenant record, not Laravel. Therefore none of Laravel's events will be fired.

I'd suggest using Laravel's events to delete the tenant record instead of CASCADE.

[skills-up]

The issue persists even without ON DELETE CASCADE.

I've called the following:

$user->tenants()->delete();
$user->delete();

The tenant gets deleted, along with associated domains. But the tenant DB remains intact.

[skills-up]

Thanks @stancl
This solved the issue. Apologies for making assumptions regarding delete events getting triggered on collection.