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 is multi-statement table-value user-defined function?
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -
Scalability, Availability, Integration with internet, etc.)?
How do I view views in sql server?
How to provide login information for a new odbc dsn?
What are system databases into sql server (2005/2008)?
What are the types of containers in ssis?
what is extended StoreProcedure ?
What is the default schema of your login session in ms sql server?
What is difference between count (*) and count column?
What is the difference between temp table and table variable?
Mention the differences between having and where clause.
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)