Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    11

    Question Unanswered: When a view is updatable and when is non?

    Hello!

    I've found out experimentally, that a view is updatable when it doesn't contain:
    1. UNION
    2. SUBQUERIES
    3. GROUP BY

    When a view contains JOIN, it's needed to find out by trying to update.

    Does anyone know the accurate list when a view is updatable?

    (I use VB6 with MSSQL2000 (2005, 2008 must support) through ADO2.8)

    Thanks in advance.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Take a look at the remarks section here:
    CREATE VIEW (T-SQL)
    George
    Home | Blog

  3. #3
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by sv2k
    Hello!

    I've found out experimentally, that a view is updatable when it doesn't contain:
    1. UNION
    2. SUBQUERIES
    3. GROUP BY
    Views with UNION ALL can be updateable. UNION DISTINCT can't.

    Views with subqueries can also be updated.

  4. #4
    Join Date
    Sep 2009
    Posts
    11
    Thank you.
    There are defferencies from Access-SQL behavior.
    I'll try to update in each case the recordsets to find out exactly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •