mexmirror

while(exists(select 1 from INFORMATION_SCHEMA.VIEWS where TABLE_SCHEMA != 'sys'))
begin
  declare @sql nvarchar(2000)
  SELECT TOP 1 @sql=('DROP VIEW [' + TABLE_SCHEMA + '].[' + TABLE_NAME
  + ']')
   FROM INFORMATION_SCHEMA.VIEWS
  WHERE TABLE_SCHEMA != 'sys'
exec (@sql)
  PRINT @sql
end