SQL - Structured Query Language

DELETE View



When drop a view, the definition of the view and other information about the view is deleted from the sysobjects, syscolumns, syscomments, sysdepends, and sysprotects system tables including all permission for the view object. The following query is used to drop existed view object from database.

-- Example 57 --

 

USE EBusiness

GO

 

IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS

        WHERE TABLE_NAME = 'EmployeeDepartment')

    DROP VIEW EmployeeDepartment

GO


Query Output Screen



* * * * *


Email Your Comment To AUTHOR