视图的创建（根据已有的表）

Create View V_CouponType
as
SELECT CouponTypeId, CouponTypeName
FROM Gas_CN_Trade_B2C.dbo.CouponType
WHERE (IsDeleted = 0)