if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[viewname]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[viewname]
gocreate view viewname
as
......
drop view [dbo].[viewname]
gocreate view viewname
as
......
调试欢乐多
drop view 视图名
gocreate view 视图名
as
........