USE [materialsM_fjse] GO /****** Object: View [dbo].[v_phinfo_gz] Script Date: 11/10/2017 15:22:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create view [dbo].[herp_invdict_view] AS select XMBM as SFXMID , GoodsBh as inv_code , Goods_Name as inv_name ,WPGG as inv_model , Unit1 as unit_name , price as plan_price ,ModifyDate as sdate from twl_product GO