The following DROP TABLE statement deletes all the records in the skill table and then removes the definition of the skill table from the database
DROP TABLE skill
Like the CREATE statement, the DROP statement automatically executes a COMMIT before and after dropping the table. This makes permanent all changes to the database since the last COMMIT or ROLLBACK.
The DROP statement also drops all indexes on the table, except if any column in the table participates in a join index.
If you only want to remove data rows but not the table itself, use the TRUNCATE TABLE statement. If you truncate a table while other users are reading from it, the normal rules of table versioning apply, that is, old table versions remain until the transactions of the readers complete; see Chapter 10, “Transactions and Versioning” for details.
DROP TABLE and TRUNCATE TABLE are very fast, taking only seconds to occur. The size of the data does not effect the speed of the operation.
For a full description of the DROP statement, see Sybase IQ Reference Manual.
Dropping a table in Sybase Central
Connect to the database.
Click the Tables folder for that database.
Right-click the table you wish to delete, and select Delete from the pop-up menu.
