--第十章--創(chuàng)建和使用視圖

--創(chuàng)建一個(gè)視圖，其中僅包括sort，truename，sex，province四個(gè)字段：
CREATE VIEW member_view_col
AS
SELECT sort, truename, sex , province 
FROM member

--視圖將僅僅顯示id>2000的記錄
CREATE VIEW member_view_row
AS
SELECT *
FROM member
Where id > 2000

--把company和chanpin表合并成一個(gè)虛擬表：
CREATE VIEW chanpin_company_view
AS
SELECT company.manager,chanpin.leibie
FROM company,chanpin
WHERE company.id = chanpin.qiyeid
GROUP BY company.manage,chanpin.leibie

--察看所有用戶的計(jì)分總額：
CREATE VIEW  sum_jifen_view
AS
SELECT jifen,
SUM(jifen)
FROM member
GROUP BY jifen

--查看數(shù)據(jù)庫(kù)表：
SELECT CompanyName, ContactName, Phone, Country
FROM dbo.Customers

--下例刪除 titles_view 視圖。
USE pubs
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
         WHERE TABLE_NAME = 'titles_view')
   DROP VIEW titles_view
GO