How to Create a View in SQL Server

Views allow to encapsulate or “hide” complexities, or allow limited read access to part of the data.

To create a view, use the CREATE VIEW command:

-- syntax
create view view_name
as select_statement;

Some examples:

-- a view to show only products within category 1
create view category_1_products_v as
select *
from products
where category = 1;

-- a view to limit read access to only certain columns
create view category_products_basic_v as
select name, category, price
from products;

-- a view that displays top 10 products that provide highest sold value
create view top_10_products_v as
  top 10,
  p.price * ps.quantity_sold as sold_value
from products p
left join products_sold ps on
order by sold_value desc;
database icon
Shared queries and folders ✅ Version history ✅ One-click connection to SQL Server ✅
Get more done, together, with PopSQL and SQL Server