---

Search posts under SQL Server:

---

SQL Server > View

In this section we are going to learn about the View in SQL server.

As the name suggest, a view is a virtual object whose result is derived from SQL query. View doesn’t contains any physical data, but all data comes from the database table. View is only stored physically in the disk when it is indexed.

Views are used to

• Filter the table data
• Hide some columns data from a database table and provide only limited set of columns
• Create a reusable set of data

Read posts under SQL Server > View

1. Creation of View in SQL Server
2. Alter a Views