Views

In this article, we will discuss views in SQL server.

Purpose

A view is a pre-written query stored on the database. A view consists of a "SELECT" statement.

Create View <View_Name>
As
<select_statement>

Consider a table "Person".

Now, create a view.

create view v_person As 
select 
  personID, 
  PersonName, 
  Address 
from 
  Person

When you press F5, a view will be created. Now, select the view (in the same way as you select the table).

select 
  PersonID, 
  PersonName 
from 
  v_Person

Syntax:

drop 
  view < view_name >

Example:

drop 
  view v_Person

Query/Feedback