What is a view? is View updatable?

Answer Posted / darshan shah

View is sub set of one or more then one tables
View is use to fetch the selected columns from one more
then one tables.
Yes we can update the view if it is not read only.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we create SQL Server 2005 Reporting Services ? Give me Sample

1740


What are character string data types in ms sql server?

796


What is a database table?

697


 Explain what is sql override for a source taLle in a mapping?

747


What is save transaction and save point?

838






How global temporary tables are represented and its scope?

718


what are the different types of replication you can set up in sql server? : Sql server database administration

745


What is sql server 2000 work load governor?

728


How to set the current database in ms sql server?

719


If a table does not have a unique index, can a cursor be opened on it?

666


Can we linked SharePoint to a SQL database?

747


Does hive support indexing?

713


what purpose does the model database serve? : Sql server database administration

670


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

716


What is attribute relationships, why we need it? : sql server analysis services, ssas

673