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
Can we use pl sql in sql server?
What is not null in sql?
Which command is used to call a stored procedure?
What is the syntax to add a record to a table?
What is the difference between delete and truncate commands?
Does user triggers have entry for trigger with compilation errors?
Explain table and field in sql?
What is form and report?
How do I find duplicates in sql?
What do you mean by stored procedures? How do we use it?
Is sql open source?
Does normalization improve performance?
what is the stuff function and how does it differ from the replace function? : Sql dba
Why triggers are used?
What is the difference between jpql and sql?