view in sql server

1/* A view is created with the CREATE VIEW statement. */
2CREATE VIEW view_name AS
3SELECT column1, column2, ...
4FROM table_name
5WHERE condition;
6
7/*example*/
8CREATE VIEW [Brazil Customers] AS
9SELECT CustomerName, ContactName
10FROM Customers
11WHERE Country = 'Brazil';
12/*query*/
13SELECT * FROM [Brazil Customers];