 Some About "VIEW" [message #273569] |
Wed, 10 October 2007 23:23  |
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
Dear fellows
it is generally said that "Views" are not updateable. but some time if we create a view consisting of only one table and having all "Not Null" Columns in it, you may update view / records in the view.
But is there any way to get an updateable view inspite of having joins(including more than one table)?????
waiting for your responce.
Regards.
|
|
|
|
|
|
| Re: Some About "VIEW" [message #274040 is a reply to message #273590] |
Fri, 12 October 2007 23:55  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
You may join as many tables as you please in an Updateable Join View, but only ONE of the tables columns will be updateable.
Let's say you are joining tables A, B, C, D, and E; and you want table A's columns to be updateable. You MUST join B, C, D, and E using the entire primary key (or a chosen unique key) from each table with equality (=) predicates. This is called "key-preservation".
Search on Key Preserved or Updateable Join View for more info.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
