Submitted Questions

  • Can i update views in SQL

    Can i update views in SQL if yes in what scenarios? if your view is joining multiple tables

    Ayushi

    • May 7th, 2015

    We can update simple views(having data from one table) and complex views(having data from multiple tables) but columns should be taken from one base table for update.

    asifeqbal

    • Mar 18th, 2015

    Yes, we can update view when view is created by single table (simple view). If we want to Update view that are based on multiple tables using Joins, Update does not work. So we used "Instead of Triggers" for updating Complex view.