SET QUOTED_IDENTIFIER OFF;
SET ANSI_NULLS ON;
SET NOCOUNT ON;
GO
IF object_id('<PREFIX,,>_<VIEW_NAME,,>', 'V') IS NOT NULL
BEGIN
PRINT 'Dropping View <PREFIX,,>_<VIEW_NAME,,>.';
DROP VIEW <PREFIX,,>_<VIEW_NAME,,>;
END
GO
/*
* ====================================================================
* BASIC INFORMATION
* ====================================================================
*
* --Project Name : <PROJECT_NAME,,>
* --Client Name : <CLIENT_NAME,,>
* --View name : <PREFIX,,>_<VIEW_NAME,,>
* --Purpose/Function : <PURPOSE,,>
* --Author : <AUTHOR,,>
* --Start Date(MM-DD-YYYY) : <START_DATE(MM-DD-YYYY),,>
*
* ====================================================================
* IMPLEMENTATION LOGIC
* ====================================================================
*
* --<IMPLEMENTATION_LOGIC,,>
*
* ====================================================================
* PERFORMANCE (To be filled up by developer,with "Yes" values)
* ====================================================================
*
* --TSQL reviewed : No
* --Indexing done properly : No
* --Index fragmentation checked: No
* --Comment : No comment
*
* ===================================================================
* REVIEW (To be filled up by reviewer,with "Yes" values)
* ===================================================================
*
* --Reviewed by : <REVIEWER_NAME,,>
* --Review date :
* --TSQL reviewed : No
* --Indexing done properly : No
* --Index fragmentation checked: No
* --Comment : No comment
*
* ===================================================================*/
-------------------------------------------------------------------------------
-- METADATA AND OTHER MESSAGES ABOVE.
-- BEGIN CREATE STATEMENTS.
-------------------------------------------------------------------------------
CREATE View [dbo].[<PREFIX,,>_<VIEW_NAME,,>]
AS
--Provide TSQL here. Modify following TSQL according to your need
SELECT top 1 * from journalists
GO
-------------------------------------------------------------------------------
-- END OF CREATE STATEMENTS.
-- METADATA AND SUCCESS/ERROR MESSAGES BELOW.
-------------------------------------------------------------------------------
IF object_id('<PREFIX,,>_<VIEW_NAME,,>', 'V') IS NOT NULL
BEGIN
PRINT 'View <PREFIX,,>_<VIEW_NAME,,> created successfully.';
END
ELSE
BEGIN
PRINT 'ERROR: Failed to create View <PREFIX,,>_<VIEW_NAME,,>.';
END
GO