1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

When is a view updatable in SQL-99?

Discussion in 'SQL - Questions and Answers' started by NIcolas Escribal, Apr 19, 2006.

  1. NIcolas Escribal Guest

    Dialect: SQL 99
    NIcolas Escribal, Apr 19, 2006
    #1

  2. ben Administrator

    The answer depends on which database server you are using.
    I know Postgres and MySQL do not allow this, even though there are some work arounds for Postgres. I am not sure about the latest MySQL (i.e. version 5.0+), it might be able to update views, but previous versions couldn't.

    I believe Oracle and MS SQL can.
    ben, Apr 19, 2006
    #2

Share This Page