Can a view be updated/inserted/deleted?If Yes under what
conditions?
Answer Posted / guest
A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is not possible.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Which tcp/ip port does sql server run?
How do you update sql?
What is an escape character in sql?
How do you optimize a stored procedure query?
what is unique key constraint? : Sql dba
Explain what is dbms?
Is a foreign key always unique?
Can we join tables without foreign key?
What are tables and fields?
what is a control file ? : Sql dba
What is difference between mysql and postgresql?
How is use pl and sql?
Can we use distinct and group by together?
How to use boolean type in select statement?
What does the sign mean in sql?