Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Deleting a Sybase table

Tech Computer Center logo
Be very careful about deleting a table! It cannot be recovered, and all the data in it will be lost. Since you can have multiple tables in your database you really don't ever need to delete a table, so don't!

At the end of each command press the space-bar or press enter before continuing the next step.

  1. If you insist on deleting a table, type
             drop table
  2. Type the table name you want to delete.
  3. Type
             go
  4. Look at what you've typed. Make absolutely certain that you never, ever want to see the data in this table again. If you absolutely, positively don't want it, press Enter. Otherwise, hold down the Control key and press C which will stop the command and keep you from making the mistake of deleting the table.

See also: Using Sybase tables
Previous: Example of Sybase table creation
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Information Technology and Communications: Help System
ITC Publications
To report a problem: File a ticket
Send mail to the User consultant on duty or call them at 575-835-5437
Home: About New Mexico Tech

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson
Last updated: 1997/06/25 19:23:01 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/table_delete.html
QR two-dimensional bar code