what is the purpose of creating view is sql server 2000
Answer Posted / kumar.t
1. View is logical representation of the table.
2. View is derived from the table.
3. view don't occupy any memory space.
purpose.
1. Security
2. Simplicity of the query.
Another Important Point : view is updatble.
By
Kumar.T
Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
Does a server store data?
Difference between aggregate functions of sql?
Define msdb database?
How can we use ConnectorJ JDBC Driver with MS SQL?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is query optimizer in sql server?
What is 4nf in normalization form?
What is the difference between char and varchar2 datatype in sql?
What authentication modes does sql server support?
How to verify the port number of the sql server?
How to get the definition of a trigger back?
How will you hide an attribute? : sql server analysis services, ssas
How can a database be repaired?
Ways to improve the performance of a SQL Azure Database?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?