what is the purpose of creating view is sql server 2000
Answer Posted / mehtab ullah
Purpose of view
Views hide data complexity.
Views add security by restricting access to the columns of a
table.
Views simplify the complex queries for the user.
View is a way to isolate application from changes in
definitions of base tables.
View is derived from the perant table.
View do not occupy any space in the memory .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is delete query?
What is sql azure database?
Tell me about normalization in DBMS.
What is a field in a table?
What is the difference between Stored Procedures and triggers?
What is exclusive locks?
What is the latest version of microsoft sql server?
Define inner join in sql server joins?
What is use of @@ spid in sql server?
What is the difference between locking and multi-versioning?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
what method you can use to reduce the overhead of Reporting Services data sources?
Do you know the policy based administration feature of sql server 2008?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is coalesce in sql server?