---
title: "View in SQL Server"  
description: "A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or mor"  
author: "Anonymous User"  
published: 2010-07-27  
updated: 2020-01-20  
canonical: https://www.mindstick.com/articles/37/view-in-sql-server  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# View in SQL Server

A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables. Based on this, before creating a view, you must first decide where its columns and records would come from. Obviously the easiest view is one whose columns and records come from one table.

Syntax for creating View

CREATE VIEW ViewName

AS

SELECT Statement

Example

CREATE VIEW view1

AS

SELECT * FROM Doctors

##### Opening or executing View

To open or execute View we use same statement as we use to use for viewing Table

records.

##### Example

SELECT * FROM view1

![View in SQL Server](https://www.mindstick.com/mindstickarticle/bfb2480d-d4e3-4eed-b7cc-66d32a60e007/images/e81b468a-9098-41e5-9e3a-e38b66dfbbf3.png)

##### Syntax for Modifying View

ALTER VIEW *ViewName*

AS

SELECT *Statement*

##### Example

ALTER VIEW view1

AS

SELECT * FROM Doctors WHERE ID>3

![View in SQL Server](https://www.mindstick.com/mindstickarticle/bfb2480d-d4e3-4eed-b7cc-66d32a60e007/images/47a83035-150f-46a3-ba48-144e070e5756.png)

##### Syntax for Deleting View

DROP VIEW *ViewName*

**Example**

DROP VIEW view1

---

Original Source: https://www.mindstick.com/articles/37/view-in-sql-server

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