View Single Post
  #2 (permalink)  
Old 04-19-2006, 04:31 AM
ben ben is offline
Administrator
 
Join Date: Mar 2007
Posts: 91
ben has disabled reputation
Default 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.
Reply With Quote