Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the purpose of creating view is sql server 2000

Answer Posted / nithya.r

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.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is blocking? : Sql server database administration

980


How to write character string constants or literals in ms sql server?

958


What is clustered primary key?

959


Does a specific recovery model need to be used for a replicated database? : sql server replication

912


Why truncate is ddl command?

993


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1756


What is an etl file?

900


Describe and explain about SQL native client?

1038


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

949


What is mean by candidate key?

948


When you use @@error and try-catch?

983


what are different types of raid configurations? : Sql server database administration

994


How do I create a stored procedure in sql server?

963


What is transactional replication?

903


What is sub query and its properties?

917