SQL判断视图是否存在并创建视图

最新推荐文章于 2025-02-15 20:30:22 发布

丶低调丶丶

最新推荐文章于 2025-02-15 20:30:22 发布

阅读量1w

点赞数

分类专栏： sql 文章标签： sql

本文链接：https://blog.csdn.net/qq_36124520/article/details/80744600

版权

sql 专栏收录该内容

9 篇文章

订阅专栏

本文提供了一段SQL脚本，用于在ZBiddingDB数据库中检查并创建视图VWinbidInfoBrowse。如果视图已存在，则会先删除再创建。视图基于多个表的数据，包括TWinbidInfo、TProject、TProjectInfo、TSection、TCustomerOrSupplier等，用于展示项目的招标信息，如项目名称、招标方、中标方、预算等详细数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

USE [ZBiddingDB]
GO

/****** Object:  View [dbo].[VWinbidInfoBrowse]    Script Date: 2018/6/20 11:46:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF  EXISTS (SELECT * FROM sysobjects WHERE name = N'VWinbidInfoBrowse')
	DROP VIEW  VWinbidInfoBrowse
GO

	CREATE VIEW [dbo].[VWinbidInfoBrowse] AS

	SELECT A.WIID,B.ProjectName,C.ProjectLegalPerson,F.SName,I.COSName AS ConstructionCompanyName,J.COSName AS WinbidCompanyName,A.ProjectId,A.SSID,A.ConstructionCompanyID,A.WinbidCompanyID,
			A.Budget,A.ProjectManager ,A.PMQCNumber,A.PMQCLevel,A.Rate,A.QualityStandard ,A.WinbidDuration ,A.WinbidContent ,A.IsDelete ,A.DeleteRemark ,
			A.CreatorAccountID ,A.CreatorName ,A.CreateDate ,A.LastEditAccountID ,A.LastEditDate, A.NegotiateTime,NegotiateAddress
	FROM TWinbidInfo A
	INNER JOIN CCMPDB.dbo.TProject AS B ON A.ProjectId = B.ProjectID   
	INNER JOIN CCMPDB.dbo.TProjectInfo AS C ON A.ProjectId =C.ProjectID
	INNER JOIN ZBiddingDB.dbo.TSection AS F ON A.SSID = F.SSID
	INNER JOIN KnowledgeDB.DBO.TCustomerOrSupplier AS I ON A.ConstructionCompanyID = I.COSID 
	INNER JOIN KnowledgeDB.DBO.TCustomerOrSupplier AS J ON A.WinbidCompanyID = J.COSID  AND A.IsDelete='0'
GO