To delete a view from the database in Interactive SQL, use the DROP statement. The following statement removes the DepartmentSize view:
DROP VIEW DepartmentSize
To drop a view in Sybase Central, right-click the view you wish to delete and select Delete from the pop-up menu.
For more information, see the Sybase Central online Help.