视图创建问题

[jasonhxm]

declare @cut int
set @cut = (select count(*) as cut from sys.views where name = 'abc')
if @cut > 0
print 'c'
else
create view abc as select * from goods

我的目的是判断库中是否存在视图'abc'，若不存在就创建。但是这样写报错，

消息 156，级别 15，状态 1，第 6 行
关键字 'view' 附近有语法错误。

请大虾帮忙指点。谢谢！

[liangCK]

if exists(select * from sys.views where name='abc')
    drop view abc;
go
create view as select * from goods;
go

[dawugui]

[Quote=引用 1 楼 liangck 的回复:]
SQL code
if exists(select * from sys.views where name='abc')
drop view abc;
go
create view as select * from goods;
go
[/Quote]就这个。

[-晴天]

create 语句应该是批的第一条语句吧.

[jasonhxm]

在库中发现存在abc，就什么都不做（不用drop），不存在abc再创建。是这样个意思。

[SQLCenter]

declare @cut int
set @cut = (select count(*) as cut from sys.views where name = 'abc')
if @cut > 0
print 'c'
else
exec ('create view abc as select * from goods')

[jasonhxm]

谢谢~~