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 |
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is Covering Indexes? Plz explain with example
How do you test your database? : sql server database administration
What is the synonym of join?
What is the command used to get the version of sql server?
Can group by and orderby be used together?
Explain differentiate between a having clause and a where clause?
What are the differences between lost updates and uncommitted dependencies?
How to rename an existing column with sql server management studio?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is indexed view? How to create it?
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)