此系统应用方便简洁

DROP VIEW { view } [ ,...n ]
下例是删除 titles_view 视图。
USE pubs
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
         WHERE TABLE_NAME = 'titles_view')
   DROP VIEW titles_view
GO