what is the purpose of creating view is sql server 2000
- 13 Answers
- 18565 Views
- Wipro, I also Faced
- E-Mail Answers
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 the default port for SQL Server over a firewall?
how you can move data or databases between servers and databases in sql server? : Sql server administration
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What do you mean by subquery?
What is primary key index?
Tell me what is difference between clustered and non clustered index?
how can you check the level of fragmentation on a table? : Sql server administration
why would you call update statistics? : Sql server database administration
What stored by the model?
What is nonclustered index on computed columns?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is difference between materialized view and view?
How can you tell if a database object is invalid?
Is it possible in sql table to have more than one foreign key?
What do you know about normalization and de- normalization?
