---
title: "What are the uses of view?"  
description: "What are the uses of view?"  
author: "Shrikant Mishra"  
published: 2020-11-03  
updated: 2020-11-03  
canonical: https://www.mindstick.com/forum/156065/what-are-the-uses-of-view  
category: "mssql server"  
tags: ["c#", "array", "programming language"]  
reading_time: 2 minutes  

---

# What are the uses of view?

What are the [uses of view](https://www.mindstick.com/forum/95354/what-are-the-uses-of-view-in-sql-server)?

## Replies

### Reply by Rahul Roi

If we are discussion about the role of views in SQL server then founded that it is kind of [**virtual tables**](https://www.mindstick.com/forum/33544/how-to-create-global-temporary-table-in-sqlserver).

A [view](https://yourviews.mindstick.com/view/84701/layoffs-in-google-india-2023-view) has also some rows and columns as they are in a real table in the database.

We can also create a view by selecting fields from one or more tables present in the database.

Where a view can either have all the rows of a table or specific rows based on certain condition.

And where the VIEW in SQL is a logical subset of data from one or more tables. And mostly, the view is used to restrict data access.

- The role of Views is - It can be represent a subset of the data contained in a table; with the result that a view can limit the degree of unveiling of the underlying tables to the outer world.
- When the listed users may have permission to query the view, And while denied access to the rest of the base table.
- And A views can [**join**](https://www.mindstick.com/forum/33572/sql-inner-join-keyword) and simplify multiple tables into a single virtual table.
- A views can enactment as aggregated tables, where the database engine aggregates data (sum, average, etc.) and presents the calculated results as part of the data
- Where a view can hide the complexity of data; for the example, the view could appear as Sales1001 or Sales2001, transparently partitioning the actual underlying table
- In the views, It takes a very little space to store the data in SQL server; And the database contains only the definition of a view, not a copy of all the data which it presents.
- The Views may provide additional security, depending on the SQL engine used.

```
Syntax for creating a View,
CREATE or REPLACE VIEW view_name
    AS
    SELECT column_name(s)
    FROM table_name
    WHERE condition
```


---

Original Source: https://www.mindstick.com/forum/156065/what-are-the-uses-of-view

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.