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 |
What does sql server mean?
What is the difference between stored procedure and user defined functions?
what are batch in sql server?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is an indice?
What is #table in sql server?
What is failover clustering overview?
What are the four main query statements?
how many non clustered index in sql server 2008,2010,2012
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Will the writetext statement activate a trigger?
Oracle (3259)
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)