IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N’[dbo].[v_pclAuditProcessing]’))
Was to create a before script containing:
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N’<%<%FullNmae%>%>’))
DROP VIEW <%<%FullNmae%>%>
GO
Unfortunately the attempt was unsuccessful.
Thanks in advance,
Terry
How would I go about adding “drop” logic to a before script using variables?
My attempt to create a view before script template… generating the following:DROP VIEW [dbo].[v_pclAuditProcessing]