中科新闻网住宅缺角是什么意思:一个SQL方面的问题
来源：百度文库 编辑：中科新闻网 时间：2024/05/15 17:33:04
谁能告诉我这段代码的含义？（详细点）
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'WOAttachView' and Type = 'V')
DROP View WOAttachView
GO
CREATE VIEW WOAttachView
AS
SELECT WOAttach.*, Attachment.name AS name
FROM WOAttach INNER JOIN
Attachment ON WOAttach.AttachmentID =
Attachment.AttachmentID
GO
这段代码怎么执行呢？
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'WOAttachView' and Type = 'V')
DROP View WOAttachView
GO
CREATE VIEW WOAttachView
AS
SELECT WOAttach.*, Attachment.name AS name
FROM WOAttach INNER JOIN
Attachment ON WOAttach.AttachmentID =
Attachment.AttachmentID
GO
这段代码怎么执行呢？
如果存在视图WOAttachView则删除
然后再创建一个这样的视图