SQL SERVER先判断视图是否存在然后再创建视图的语句

IF EXISTS(SELECT 1 FROM sys.views WHERE name='Report_IndividualTicket')

DROP VIEW Report_IndividualTicket

GO

create view Report_IndividualTicket

as

SELECT Ticket.TicketNumber, Ticket.TicketID,

GisProcess.StageName,

Content.DtReceived, Content.ContentText

FROM

(GisProcess INNER JOIN Ticket

ON GisProcess.TicketID=Ticket.TicketID)

INNER JOIN Content

ON Ticket.ContentID=Content.ContentID

GO