What is a view? is View updatable?

Answer Posted / harinireddy

view is a virtual table created from the physical table
which is existing.view can be updated unless the base table
does not have any relation u another table

Is This Answer Correct ?    14 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we add an identity column to decimal datatype?

584


How can I check if a view exists in a sql server database?

567


Explain “@@rowcount” and “@@error” in sql server?

541


What are the system database in sql server 2005?

556


Do you have any idea about the tcl commands?

553






How does Report Builder support Analysis Services cubes?

110


How to generate create view script on an existing view?

562


Explain transaction server explicit transaction?

507


How to execute a stored procedure in ms sql server?

554


Why I have to use stored procedures?

598


Explain concepts of analysis services?

513


Give an example of SQL injection attack ?

570


What are different types of replication in sql server?

572


What is query optimization process?

520


What is report subscription?

91