If a View on a single base table is manipulated will the
changes be reflected on the base table?
Answer Posted / papal
yes if there is no use of "CHECK WITH option"
then definitally chnages in view affects the base table
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is pivot query?
Can you join views in sql?
Can I create table without primary key?
what is a trigger in mysql? : Sql dba
how to convert dates to character strings? : Sql dba
What is the difference between microsoft sql and mysql?
How do I debug a stored procedure?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What are the different dcl commands in sql?
What are the types of join in sql?
How do I audit the sql sent to the server?
What is native sql query?
What are aggregate and scalar functions?
What are sql functions? Describe in brief different types of sql functions?
How do I edit a trigger in sql developer?