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 is trigger and types?
What is the unique index?
how does a local variable is defined using t-sql? : Transact sql
What is mutating sql table?
What is pl sql record in oracle?
Is primary key an index?
What is an alias command?
What is sql dialect?
tell me about various levels of constraint. : Sql dba
What is sql mysql pl sql oracle?
How can the performance of a trigger be improved?
How do I start sql profiler?
Explain the uses of a database trigger?
what is the functionality of the function htmlentities? : Sql dba
what is 'trigger' in sql? : Sql dba