Tricky Facts About views

  1. Restrictions on Updating Data Through Views You can insert, update, and delete rows in a view, subject to the following limitations:
  2. Cool Gadgets

  3. If the view contains joins between multiple tables you can only insert and update one table in the view, and you can’t delete rows.
  4. You can’t directly modify data in views based on union queries. You can’t modify data in views that use GROUP BY or DISTINCT statements.
  5. All columns being modified are subject to the same restrictions as if the statements were being executed directly against the base table.
  6. Text and image columns can’t be modified through views.

One thought on “Tricky Facts About views

  1. I see your blog needs some unique & fresh
    content. Writing manually is time consuming,
    but there is solution for this hard task. Just search for:
    Miftolo’s tools rewriter

Leave a Reply

Your email address will not be published. Required fields are marked *