What is a view? is View updatable?

Answer Posted / kumaran

A view is a Virtual Table or a Logical representation.
View type :- SimpleView and Complex View.
Simple views are updatable.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain different types of constraints? : Sql server database administration

518


What is 'write-ahead log' in sql server 2000 ?

627


How to defragment table indexes?

550


How do you migrate data from mssql server to azure?

151


How to attach adventureworkslt physical files to the server?

633






What is blocking and how would you troubleshoot it? : sql server database administration

591


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

623


Which tcp/ip port does sql server run on? How can it be changed?

574


What is bcp? When does it use?

515


How to connect to SQL Azure Database by using sqlcmd?

110


How can I get data from a database on another server?

515


If we delete pack Spec what will be the status of pack Body ?

968


What is the difference between varchar and varchar types?

568


Explain timestamp datatype?

552


Explain how many types of relationship?

575