Suggest an editImprove this articleRefine the answer for “Can you delete data through a view?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)Yes, **you can delete data through a view**, but - just like with insert and update - **only if the view is simple**: it has to be built on **a single table**, with no `JOIN`, `GROUP BY`, `DISTINCT`, subqueries, or aggregate functions. **Key point:** if a view is complex (e.g. it combines several tables), **you can't delete through it** - the database doesn't know which specific table to remove the data from.Shown above the full answer for quick recall.Answer (EN)ImageYes, **you can delete data through a view**, but - just like with insert and update - **only if the view is simple**. That is, it has to be built on **a single table**, with no `JOIN`, `GROUP BY`, `DISTINCT`, subqueries, or aggregate functions. ### Example: it works ```sql CREATE VIEW active_users AS SELECT id, name FROM users WHERE is_active = 1; DELETE FROM active_users WHERE id = 5; ``` This command deletes the record from the `users` table, because `active_users` references it directly. But if a view is complex (e.g. it combines several tables), then **you can't delete through it** - the database doesn't know which specific table to remove the data from.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.