What is a view? is View updatable?

Answer Posted / amit upadhyay

VIEW :- VIEW IS VIRTUAL TABLE. WHICH GIVE ACCESS TO SUBSET
OF COLUMN OF THE TABLES.

VIEW CAN BE UPDATED THAT GET EFFECTED THE TABLE ALSO.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a data collection table?

737


How do you delete duplicate records in sql server?

727


How do you delete a data source?

759


What happens if ntwdblib.dll is missing on your machine?

883


How do I install sql server?

629


Do you know spatial data types - geometry and geography in sql server 2008?

776


How will you make an attribute not process? : sql server analysis services, ssas

762


Tell me what is a linked server?

774


What is 'Join' and explain its various types.

813


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1586


How to change a login name in ms sql server?

716


what are user defined datatypes? : Sql server database administration

726


Explain trigger and trigger types?

739


Explain the usage of floor function in sql server.

685


What are the different types of stored procedures?

808