Whether the updations made to the views reflect the
original records in the table
Answers were Sorted based on User's Feedback
Answer / sabareetha
If the view is created with single table. Updating a view
will affect the origival records in the table
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / ravi sharma
in the case if same table (all column) are make a view then
updations reflect the original record in the table.
but mostly make a view to security purpose the , uniques
are constaint column are not use,
then not be reflect .
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / soorai ganesh
No. Updating View will not affect the table records.
| Is This Answer Correct ? | 9 Yes | 13 No |
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the difference Between Sql-server 2000 & 2005
What is a transactions?
What is enhanced database mirroring in sql server 2008?
What about UPDATESTATISTICS ?
Define self join in sql server joins?
Detail about the hardware which is supported by SQL server?
What are the 2 types of classifications of constraints in the sql server?
What is measure group, measure? : sql server analysis services, ssas
Do you know how to store and query spatial data?
How to query multiple tables jointly?
What is the query and subquery?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)