Use the CREATE VIEW statement to create a view on existing tables or views. You specify the name for the VIEW.
The following example demonstrates the use of a code sample. The statement is used to retrieve information from the customer base, but only information on those customers located within the six New England states.
CREATE VIEW ne_customer AS
SELECT cust_no, last_name, street, city, state
FROM SPORTS.customer
WHERE state in ('NH', 'MA', 'ME', 'CT', 'RI', 'VT') ;
