|
|
|
| SQL - Structured Query Language |
DELETE ViewWhen 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 |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR