来自「JAVA下的SQL_System的建立」· 代码 · 共 8 行

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