ASA SQL User's Guide
  Working with Database Objects
    Working with views

Deleting views

You can delete a view in both Sybase Central and Interactive SQL.

To delete a view (Sybase Central)

1. Open the Views folder.

2. Right-click the desired view and choose Delete from the popup menu.

To delete a view (SQL)

1. Connect to a database with DBA authority or as the owner of the view.

2. Execute a DROP VIEW statement.

Examples 

Remove a view called DepartmentSize.

DROP VIEW DepartmentSize

For more information, see DROP statement.