What is a view? is View updatable?

Answer Posted / sai krishna.k

a view is nothing but a logical representation of tables.
it is also called as "virtual table".
a view may be updatable view or non updatable view.

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it ok to shrink transaction log?

519


How to generate create procedure script on an existing stored procedure?

514


what protocol both networks use? : Sql server database administration

542


What are the different types of stored procedures?

556


What is difference between cte and view?

526






What is the difference between lock, block and deadlock? : sql server database administration

566


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1577


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

524


What are the dis_advantages of stored procedures, triggers, indexes?

1689


What is built-in/administrator?

576


What do we need queues in sql service broker?

526


What is difference between sql and sql server?

546


What is the purpose of the model database?

598


What are the acid properties?

553


Can two tables share a primary key?

520