Click here to Skip to main content
15,868,005 members
Please Sign up or sign in to vote.
1.44/5 (2 votes)
See more:
can any one explain views concept in sqlserver
Posted
Updated 22-Sep-22 20:30pm

SQL
In SQL, a view is a virtual table based on the result-set of an SQL statement.

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.


SQL
CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition


refer http://www.w3schools.com/sql/sql_view.asp[^]
 
Share this answer
 
Yes, google[^]!
 
Share this answer
 
In SQL, a View is just a virtual table that is constructed based on the results of another SQL operation. Views were created to simplify data delivery and reduce the complexity of numerous tables. Views assist us in maintaining data integrity and providing data security, so acting as a security mechanism.

Hope this small definition helps.
 
Share this answer
 
Comments
OriginalGriff 23-Sep-22 6:57am    
While I applaud your urge to help people, it's a good idea to stick to new questions, rather than 8 year old ones. After that amount of time, it's unlikely that the original poster is at all interested in the problem any more!

Answering old questions can be seen as rep-point hunting, which is a form of site abuse. Particularly when your answer doesn't really add anything to existing answers. The more trigger happy amongst us will start the process of banning you from the site if you aren't careful. Stick to new questions and you'll be fine.
Sarang Techie 23-Sep-22 7:02am    
Yeah, you are right. Sure, I will definitely keep this in my mind.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900