Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE VIEW MY_VIEW AS
- SELECT SOME_FIELD
- FROM SOME_TABLE
- WHERE SOME_CONDITIONS
- if exists (select * from dbo.sysobjects
- where id = object_id(N'dbo.MyView') and
- OBJECTPROPERTY(id, N'IsView') = 1)
- drop view dbo.MyView
- go
- create view dbo.MyView [...]
- if exists (select * from dbo.sysobjects
- where id = object_id(N'dbo.MyView') and
- OBJECTPROPERTY(id, N'IsView') = 1)
- drop view dbo.MyView
- go
- create view dbo.MyView [...]
- IF OBJECT_ID('[dbo].[myView]') IS NOT NULL
- DROP VIEW [dbo].[myView]
- GO
- CREATE VIEW [dbo].[myView]
- AS
- CREATE PROCEDURE dbo.DropView
- @ASchema VARCHAR(100),
- @AView VARCHAR(100)
- AS
- BEGIN
- DECLARE @sql VARCHAR(1000);
- IF OBJECT_ID('[' + @ASchema + '].[' + @AView + ']') IS NOT NULL
- BEGIN
- SET @sql = 'DROP VIEW ' + '[' + @ASchema + '].[' + @AView + '] ';
- EXEC(@sql);
- END
- END
- EXEC dbo.DropView 'mySchema', 'myView'
- GO
- CREATE View myView
- ...
- GO
- IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_myView]'))
- EXEC sp_executesql N'CREATE VIEW [dbo].[vw_myView] AS SELECT ''This is a code stub which will be replaced by an Alter Statement'' as [code_stub]'
- GO
- ALTER VIEW [dbo].[vw_myView]
- AS
- SELECT 'This is a code which should be replaced by the real code for your view' as [real_code]
- GO
Add Comment
Please, Sign In to add comment