SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO
-- =============================================
-- Create: 2017-11-23 liyu
-- Description: 创建视图demo
-- =============================================
CREATE VIEW [dbo].[v_test] WITH
--SCHEMABINDING,
VIEW_METADATA
AS
SELECT
pt_part = tip.tipt_pt_part,
pt_name = tip.tipt_pt_desc,
pt__chr04 = tip.tipt_comp_class,
pt_part_class = tip.tipt_prod_class,
acctid = tip.acctid
FROM dbo.tme_table AS tip
WHERE tip.isenable = 1
WITH CHECK OPTION;
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- Create: 2017-11-23 liyu
-- Description: 创建视图demo
-- =============================================
CREATE VIEW [dbo].[v_test] WITH
--SCHEMABINDING,
VIEW_METADATA
AS
SELECT
pt_part = tip.tipt_pt_part,
pt_name = tip.tipt_pt_desc,
pt__chr04 = tip.tipt_comp_class,
pt_part_class = tip.tipt_prod_class,
acctid = tip.acctid
FROM dbo.tme_table AS tip
WHERE tip.isenable = 1
WITH CHECK OPTION;
GO