Return to Snippet

Revision: 8935
at October 14, 2008 13:49 by hoffstein


Initial Code
IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'v_MyView') BEGIN
    DROP VIEW dbo.v_MyView
    PRINT 'Dropped dbo.v_MyView'
END

Initial URL

                                

Initial Description

                                

Initial Title
TSQL delete view if it already exists

Initial Tags

                                

Initial Language
SQL