杭州交通信息网npt1 4内螺纹的尺寸:一个SQL方面的问题
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/30 11:01:34
谁能告诉我这段代码的含义？（详细点）
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则删除
然后再创建一个这样的视图