If a View on a single base table is manipulated will the
changes be reflected on the base table?
Answer Posted / naresh
Hi
Not only on a single based table, changes made on a view
which created on multiple tables also will update on base
tables,if the relation ship between primary key and Foreign
key relationships are proper and if the Integrity
constraints are mentioned.
Cheers!
Naresh
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is sql injection vulnerability?
What is using in sql?
How do I make my sql query run faster?
How do you create an update query?
How to run sql functions in pl/sql?
Why is the cursor important?
What is the difference between sql, mysql and sql server?
What is a .db file?
what are local and global variables and their differences? : Sql dba
Which query operators in sql is used for pattern matching?
Explain correlated query work?
What is sql deadlock?
What is the purpose of the primary key?
What found sql?
what are the different functions in sorting an array? : Sql dba