Database objects, such as tables, views, secondary indexes, and synonyms, can be deleted (dropped). When you drop a table, objects that are directly dependent on that table, such as indexes and views, are automatically dropped.

In SQL, you can accomplish this task using the DROP statement. For details, see the SQL Reference Guide.

In Director, right-click the object in the Instance Explorer and select Delete.

In VDBA, you can perform this task in the Database Object Manager window. The online help topic Dropping Objects gives a generic description for dropping any type of database object. Each type of object has its own help topic, such as Dropping a Table or Dropping a View. If for some reason you cannot drop tables in VDBA, you can use another method. More information can be found in Verifying Databases (see page Verifying Databases).