what is the purpose of creating view is sql server 2000
A view is a virtual table. A view serves as a security mechanism. If we have several tables in a database and we want to view only specific columns from specific tables we can go for views. Using view we can avoid the complex queries.