You can use Sybase Central to drop a table from your database, for example, when you no longer need it.
You must be the owner, or have the DROP ANY TABLE or DROP ANY OBJECT system privilege.
You cannot drop a table that is being used as an article in a publication. If you try to do this in Sybase Central, an error appears. Also, if you are dropping a table that has dependent views, there may be additional steps to take.
Dropping tables fails if there are any dependent materialized views; you must first disable dependent materialized views. Use the sa_dependent_views system procedure to determine if there are dependent materialized views.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Right-click the table and click Delete.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|