Wednesday, 24 May 2017

Delete All View In SQL Server

DECLARE @VIEWNAME VARCHAR(1000); 

DECLARE curs CURSOR
FOR
    SELECT  [name]
    FROM    sys.objects
    WHERE   TYPE = 'V'; 

OPEN curs; 
FETCH NEXT FROM curs INTO @VIEWNAME; 
WHILE @@fetch_status = 0
    BEGIN 
        EXEC('DROP VIEW ' + @VIEWNAME); 
        PRINT 'DELETED VIEW -> ' + @VIEWNAME;
        FETCH NEXT  FROM curs INTO @VIEWNAME;
    END; 
CLOSE curs; 
DEALLOCATE curs;

No comments:

Post a Comment