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
How do I view views in sql server?
What is raid, and how it can influence database performance?
Explain how you can configure a running aggregate in SSRS?
Is foreign key unique?
What does <> symbol mean?
What does it mean to normalize data?
What language is sql server written in?
how many triggers you can have on a table? : Sql server database administration
How can you list all the table constraints in a database?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is database mirroring?
query processing
What is a file group?
What is the importance of concurrency control?
Define the one-to-one relationship while designing tables.