if i perform any operation on views such as insert, delete
etc will my base table get affected?????
Answer Posted / gourvendra singh
It will affect ur base table only when u having a simple
view and if you put null in the field which is primary key
of the base table then also the base table will not
affected. And if you are using the compute view then u r nt
able to insert or delete the records.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is trigger and types?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
How do I access sql anywhere database?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is before trigger?
What are the built in functions of sql?
What is trigger types in sql?
What is sql catalog?
how to delete an existing column in a table? : Sql dba
What are tables and fields?
What does stand for in sql?
Why do we need view in sql?
what is schema? : Sql dba
What is Histogram?