Header N Footer For Taking Scripts

Stored Procedures

********************

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Template_GetSubDropdown')

BEGIN

DROP  Procedure  Template_GetSubDropdown

PRINT 'Template_GetSubDropdown DROPPED'

END

GO

GO

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Template_GetSubDropdown')

BEGIN

PRINT 'Template_GetSubDropdown CREATED.'

END

GO

Scalar-Valued Functions

**************************

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'FN' AND name = 'FN_GetDeleteOptionForTemplate')

BEGIN

DROP  FUNCTION  FN_GetDeleteOptionForTemplate

PRINT 'FN_GetDeleteOptionForTemplate DROPPED'

END

GO

GO

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'FN' AND name = 'FN_GetDeleteOptionForTemplate')

BEGIN

PRINT 'FN_GetDeleteOptionForTemplate CREATED.'

END

GO

Table-Valued Functions

**********************

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'TF' AND name = 'FN_GettemplateIdFromProjectType')

BEGIN

DROP  FUNCTION  FN_GettemplateIdFromProjectType

PRINT 'FN_GettemplateIdFromProjectType DROPPED'

END

GO

GO

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'TF' AND name = 'FN_GettemplateIdFromProjectType')

BEGIN

PRINT 'FN_GettemplateIdFromProjectType CREATED.'

END

GO