View is used to fetches the data from existing table and it doesn't

what is the purpose of creating view is sql server 2000

Question Posted / thirumal

Answer Posted / thirumal

View is used to fetches the data from existing table and it
doesn't occupy any space in memory.

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are different types of database indexes?

1104

What is a view and what are its advantages?

1114

1 01 101 01010

2058

How do you use a subquery to find records that exist in one table and do not exist in another?

1051

Explain the creation and execution of a user-defined function in the sql server?

1053

What does it mean to manipulate data?

1001

What the different components in replication and what is their use?

954

can you instantiate a com object by using t-sql? : Sql server database administration

1004

What is a self join in sql server?

1141

What is the osql utility?

975

How to select true false based on column value in sql server?

1036

What is the sql case statement used for?

1104

What do you understand by physical_only option in dbcc checkdb?

981

How to generate create view script on an existing view?

988

Explain the use of containers in ssis and also their types?

970