SQL - Views
Overview
Views encapsulate a SELECT as a virtual table for reuse and security.
CREATE VIEW v_high_earners AS
SELECT first_name, salary
FROM employees
WHERE salary > 100000;
SELECT * FROM v_high_earners;
DROP VIEW v_high_earners;
CREATE VIEW dbo.v_high_earners AS
SELECT first_name, salary
FROM dbo.employees
WHERE salary > 100000;
SELECT * FROM dbo.v_high_earners;
DROP VIEW dbo.v_high_earners;
CREATE VIEW v_high_earners AS
SELECT first_name, salary
FROM employees
WHERE salary > 100000;
SELECT * FROM v_high_earners;
DROP VIEW v_high_earners;