Dropping a Table

You can drop ordinary tables and proxy tables. When you drop a table, you delete both the table and all the data it contains.

Prerequisites 

Before you can drop a table, be sure to connect to the data server that contains the table.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Find the table or proxy table you want to drop.
    Table type How to access
    Regular database table Expand the Tables folder.
    Proxy table Expand the Proxy Tables folder.
  3. Right-click the table and select Drop.
Related tasks
Creating a Table
Renaming a Table
Truncating Table Data
Creating an ASE Nonsharable Temporary Table
Creating a SQL Anywhere or a Sybase IQ Temporary Table
Granting and Revoking Table Permissions

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com