if i perform any operation on views such as insert, delete
etc will my base table get affected?????
- 4 Answers
- 9379 Views
- I also Faced
- E-Mail Answers
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
explain access control lists. : Sql dba
how to analyze tables with 'mysqlcheck'? : Sql dba
what is the difference between $message and $$message? : Sql dba
Why are cursors used?
What is on delete set null?
what happens if you no create privilege in a database? : Sql dba
what is auto increment? : Sql dba
What does the base_object_type column shows in the user.triggers data dictionary view?
Can function return multiple values in sql?
what is text? : Sql dba
Which are the different types of indexes in sql?
What is numeric function sql?
Is left join faster than inner join?
what is denormalization. : Sql dba
How do you define a foreign key?
