SQL CREATE VIEW 关键字
CREATE VIEW
The CREATE VIEW
command creates a view.
视图是一个基于 SQL 语句结果集的虚拟表。
The following SQL creates a view that selects all customers from Brazil
示例
CREATE VIEW [Brazil Customers] AS
SELECT CustomerName, ContactName
FROM Customers
WHERE Country = "Brazil";
Query The View
We can query the view above as follows
示例
SELECT * FROM [Brazil Customers];