DX们，急着问一个问题，谢谢

[wofan]

想进行这样的操作

如果数据库里面有VW_1这个视图就删除，没有就不用理会，然后重新创建新的视图

这该怎样写？

[netcoder]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[视图名]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[视图名]
GO

CREATE VIEW dbo.视图名
AS
……

[wofan]

谢了

[zjmym]

USE databasename
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'viewname')
DROP VIEW viewname
GO
CREATE VIEW viewname
AS
your sql
GO

[zjcxc]

if object_id('VW_1') is not null
drop view VW_1
go

create view VW_1
as
...