使用SSMS创建视图
使用T-SQL语句创建视图
CREATE VIEW view_name
AS
<SELECT 语句>
使用T-SQL语句删除视图
IF EXISTS(SELECT * FROM sysobjects WHERE name='view_name')
DROP VIEW view_name
使用T-SQL语句查看视图
SELECT * FROM view_name
--使用T-SQL语句创建视图
--1、视图的内容来源与一张表
IF EXISTS(SELECT * FROM sysobjects WHERE name='view_name')
DROP VIEW view_name
GO
CREATE VIEW vw_UserInfo --CREATE VIEW 必须是批处理中的第一条语句
AS
SELECT UserId AS 登录名,UserName AS 姓名,Email AS 邮箱,UserAddress AS 地址,Pheno AS 电话 From UserInfo
--2、视图的内容来源于多张表,并且带查询调节
IF EXISTS(SELECT * FROM sysobjects WHERE name='vw_Commodity')
DROP VIEW vw_Commodity
CREATE VIEW vw_Commodity
AS
SELECT * FROM CommodityInfo AS C
INNER JOIN CommoditySort AS S ON C.SortId
WHERE S.SortName='图书音像'