What is a view? is View updatable?

Answer Posted / subhash chandra

views snapsot of multiple table into one one vertual table.
views can be update,insert,delete,its effect base tables
depend upon..
if you update/insert when- base table is multiples/sigle
respectively

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the index requirement in SQL Azure?

72


What are the differences between DDL, DML and DCL in SQL?

758


Do you know what is a trace frag? Where do we use it?

558


What is page-level compression?

553


How to call a function from a stored procedure in SQL Server ?

551






What is correlated subquery in sql server?

559


Can a rule be bound to any column of any data type?

567


how to control the amount of free space in your index pages? : Sql server database administration

598


How many databases instances are there in sql server 2000?

579


What is buffer cash and log cache in sql server?

593


What is report rendering ?

102


What is NOT NULL Constraint in sql server 2012?

603


How to use order by with union operators in ms sql server?

577


Do you know what is lock escalation?

582


How you can get a list of all the table constraints in a database?

517