The view referenced by table_or_view_name must be updatable and reference exactly one base table in the FROM clause of the view definition. For more information about updatable views, see CREATE VIEW ...

Learn the basic syntax and examples of the SQL DELETE statement, as well as its limitations and alternatives, for deleting data from a table in a relational database.

Learn how to delete a data source view (DSV) in SQL Server Analysis Services (SSAS) without affecting the cubes and dimensions that depend on it.

Repository that contains sql views snippets and tricks for DHIS2 database operations - ibrahimwickama/dhis-sqlviews ...