Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL SQL-Server
I want to know view store data,
 
when I execute,
 
select * from View
 
or It is contains data as table.
Posted 10-Nov-12 16:36pm
ExpertITM1.2K
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

In database theory, a view consists of a stored query accessible as a virtual table in a relational database. A view does not form part of the physical schema: it is a dynamic, virtual table computed or collated from data in the database.
 
Refer below link:
 
http://www.c-sharpcorner.com/UploadFile/6cde20/concept-of-view-in-sql-server/[^]
 
Views In SQL Server[^]
 
http://en.wikipedia.org/wiki/View_(database)[^]
  Permalink  
Comments
Sergey Alexandrovich Kryukov at 11-Nov-12 1:07am
   
My 5.
--SA
Shanalal Kasim at 11-Nov-12 1:43am
   
Thanks
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

A view is only a logical representation of data.
Data is still stored in tables.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 363
1 OriginalGriff 344
2 George Jonsson 238
3 Shemeemsha RA 148
4 Animesh Datta 130
0 OriginalGriff 6,179
1 Sergey Alexandrovich Kryukov 5,616
2 CPallini 4,770
3 George Jonsson 3,400
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 11 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100