L0f6vLKn

1IF Object_ID('TestView') IS NULL
2	BEGIN
3		create view TestView
4		as
5		. . .
6	END
7ELSE
8	BEGIN
9		ALTER view TestView
10		as
11		. . .	
12	END
13	
14IF Object_ID('TestView') IS NOT NULL
15    DROP VIEW TestView
16
17CREATE VIEW TestView
18   as
19   . . .
20
21GO
22	
23DECLARE @SQL as varchar(4000)
24
25-- set to body of view
26SET @SQL = 'SELECT X, Y, Z FROM TABLE' 
27
28IF Object_ID('TestView') IS NULL
29    SET @SQL = 'CREATE VIEW TestView AS ' + @SQL
30ELSE    
31    SET @SQL = 'ALTER VIEW TestView AS ' + @SQL
32
33EXEC(@SQL)
34	
35IF OBJECT_ID('TestView') IS NOT NULL
36BEGIN 
37
38DROP VIEW TestView
39END
40
41GO
42
43CREATE VIEW TestView
44
45AS 
46
47SELECT * FROM TestTable
48	
49IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[testView]'))
50    DROP VIEW [dbo].[testView]
51GO
52
53CREATE VIEW [dbo].[testView]
54AS
55	
56if object_id('demoView') is null
57    sp_executesql 'create view demoView as select * from demoTable'