To delete a view from the database in Interactive SQL , use the DROP statement. The following statement removes the DepartmentSize view:
DROP VIEW DepartmentSize