---
title: "What is View in Database?"  
description: "What is View in Database?"  
author: "Anonymous User"  
published: 2010-10-20  
updated: 2020-09-22  
canonical: https://www.mindstick.com/interview/60/what-is-view-in-database  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is View in Database?

A *view* can be thought of as either a virtual table or a stored query. Unless a *view* is indexed, its data is not stored in the *database* as a distinct object.\
\
Syntax:\
CREATE VIEW view_name AS\
SELECT column_name(s)\
FROM table_name\
WHERE condition\

## Answers

### Answer by Rajesh Goswami

A *view* can be thought of as either a virtual table or a stored query. Unless a *view* is indexed, its data is not stored in the *database* as a distinct object.\
\
Syntax:\
CREATE VIEW view_name AS\
SELECT column_name(s)\
FROM table_name\
WHERE condition\


---

Original Source: https://www.mindstick.com/interview/60/what-is-view-in-database

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