/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
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