|SQL - Structured Query Language|
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 --
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'EmployeeDepartment')
DROP VIEW EmployeeDepartment
Query Output Screen
* * * * *