SQL SERVER OBJECT TEMPLATES -- VIEW

Template for creating a view in sql server is provided below:
--------------------------------------------------------------------------

/******************************************************************
======== BEGIN MAINTENANCE WRAPPER ==========
******************************************************************/
-- Check if the view already exists


IF EXISTS ( SELECT 1
FROM sysobjects
WHERE name = 'VW_VIEW_NAME'
AND uid = user_id('dbo')
AND type = 'V' )
-- P = Proc; V = View; U = Table; TR = Trigger
BEGIN

-- If it exists, drop to recreate the view

DROP VIEW dbo.VW_VIEW_NAME
PRINT 'VIEW VW_VIEW_NAME DROPPED SUCCESSFULLY'
END

ELSE
BEGIN
PRINT 'VIEW VW_VIEW_NAME DROPPED FAILED'
END

GO
/******************************************************************
======== END MAINTENANCE WRAPPER ==========
******************************************************************/
/********************************************************
** REVISION HISTORY : *
** ====================== *
** DATE VERSION NAME COMMENTS *
** ---------- ------- ----------------- -----------------*
** MM/DD/CCYY 1.0 Developer Name Initial Draft *
** *
*****************************************************************/

CREATE VIEW dbo.VW_VIEW_NAME(
)
AS
/* view Body */
GO

/******************************************************************
======== BEGIN MAINTENANCE WRAPPER ==========
******************************************************************/
-- Check for errors in creating the view


IF EXISTS ( SELECT 1
FROM sysobjects
WHERE name = 'VW_VIEW_NAME'
AND uid = user_id('dbo')
AND type = 'V' )
-- P = Proc; V = View; U = Table; TR = Trigger
BEGIN
PRINT 'VIEW VW_VIEW_NAME CREATED SUCCESSFULLY'
END
ELSE
BEGIN
PRINT 'VIEW VW_VIEW_NAME CREATION FAILED'
END
GO
/******************************************************************
======== END MAINTENANCE WRAPPER ==========
******************************************************************/
-- SELECT * FROM dbo.VW_VIEW_NAME

This entry was posted in . Bookmark the permalink.

Leave a reply