CREATE VIEW view_name AS
SELECT column_list FROM table_name WHERE condition;
CREATE VIEW [Current Product List] AS SELECT ProductID,ProductName FROM Products WHERE Discontinued='No';GROUP BY CategoryNameCREATE OR REPLACE VIEW [Current Product List] AS
SELECT ProductID,ProductName,Category FROM Products WHERE Discontinued='No';
DROP VIEW view_name;
CREATE OR REPLACE VIEW vw_occupied_seats_by_class AS
SELECT c.course_designater_fk AS "COURSE", b.seat_num,
a.firstname || ' ' || a.lastname AS "STUDENT"
FROM students a
JOIN classregistration b ON a.student_id = b.student_id_fk
JOIN classes c ON c.classes_num = b.classes_num;
使用視圖簡化業務查詢：單課程座位、統計空座位數等。
CREATE OR REPLACE VIEW vw_name_conflict AS
SELECT a.classes_num "CLASSES_CLASSES_NUM",
b.classes_num "CLASSREGISTRATION_CLASSES_NUM"
FROM classes a JOIN classregistration b ON a.classes_num = b.classes_num;
視圖列名必須唯一，別名消除歧義。
