| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
04-19-2006, 04:31 AM
|
|||
|
|||
ANY answer.
Re: When is a view updatable in SQL-99?
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.     
|
