A view is a virtual table. A view consists of rows and columns just like a table. The difference between a view and a table is that views are definitions built on top of other tables (or views), and do not hold data themselves. If data is changing in the underlying table, the same change is reflected in the view. A view can be built on top of a single table or multiple tables. It can also be built on top of another view. In the SQL Create View page, we will see how a view can be built. Views offer the following advantages: 1. Ease of use : A view hides the complexity of the database tables from end users. Essentially we can think of views as a layer of abstraction on top of the database tables. 2. Space savings : Views takes very little space to store, since they do not store actual data. 3. Additional data security : Views can include only certain columns in the table so that only the non-sensitive columns are included and exposed to the end user. In addition, some databases allow views to have different security settings, thus hiding sensitive data from prying eyes Refer http://www.1keydata.com/sql/sql-view.html

Answer

SQL View

Swati Agarwal

12y

1.3k

What is a SQL view?

Answers (1)

Next Recommended Forum

Query n# of Records

BCP in SQL

Leaderboard

View all

Mahender Pal

Abiola David

Venkatasubbarao Polisetty

View all

Yesterday's leader

Mahender Pal

Dynamics CRM, Dynamics 365 CE, PowerApps

India

2.7m

51.9k

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

181

287.9k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.1k

58k

Upcoming events

View all

What is the Workflows: Dapr in Action - Ep. 10
What is the Actors: Dapr in Action - Ep. 11
.NET Conference 2025

Suggested for you

View all

Nakul Chaudhari

John Godel

Sreeparna Sreejay

U T

Jaydeep Suryawanshi

Forum Statistics

Please welcome our newest member rendou .
3,076,869 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 11 new threads, 35 new posts, and 141 new users.
In last week, the most popular thread is 'Delta lake vs Lakehouse in Fabric?'.