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 primary key, unique key, and foreign key?
What is 2nf normalization form?
What is Replication?
which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help
How to defragment table indexes?
How to find out name of all employees who has salary less than 200 Rs.?
Can we write ddl in trigger?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Is it safe to delete log files?
What are the purposes and advantages stored procedure?
What is named query? : sql server analysis services, ssas
What are commonly used mssql functions in php?
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)