SQL Server : CREATE VIEW

Make sure you are using the correct database;

USE MyDatabase;
GO

Create a view.

CREATE VIEW employees_v as
SELECT employee_id,
       first_name + ' ' + last_name as employee_name,
       date_of_birth
FROM employees;

Display the data using the view.

SELECT * FROM employees_v;

Drop the view.

DROP VIEW employees_v;

For more information see:

• CREATE VIEW (Transact-SQL)
• DROP VIEW (Transact-SQL)