what is the purpose of creating view is sql server 2000
View is used to fetches the data from existing table and it doesn't occupy any space in memory.